[thelist] MYSQL Select from Table(s)

[sulasmin suruji]

--- Anthony Baratta <Anthony at Baratta.com> wrote:
> 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
> 
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/