[thelist] MYSQL Select from Table(s)

[Anthony Baratta]

At 09:39 PM 4/19/2001, you wrote:
>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

Note:

This will only return info if all three columns have data to report from 
the join.



----
Anthony Baratta
President
Keyboard Jockeys