[thelist] MYSQL Select from Table(s)
sulasmin suruji
sazmin_alyin at yahoo.com
Fri Apr 20 02:46:24 CDT 2001
--- 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/
More information about the thelist
mailing list