[thelist] MYSQL Select from Table(s)

[Anthony Baratta]

What other data do you want from the other tables??

If you want state info from each table, try this:

SELECT tblAds.State as Ads_State,
tbleDockets.State as Dock_State,
tblReward.State as Reward_State
FROM
tblAds,tbleDockets,tblReward
WHERE tblAds.Email ='$email'
AND tblAds.State = tbleDockets.State
AND tblAds.State = tblReward.State
----
Anthony Baratta
President
Keyboard Jockeys