[thelist] complicated sql

[Andrew Martin]

Hey, thanks everyone for the tips.  I'll try it all out and let you know if
I can solve this.

Thanks again for your help!



----- Original Message ----- 
From: "Rob Smith" <rob.smith at THERMON.com>
To: <thelist at lists.evolt.org>
Sent: Monday, December 08, 2003 6:29 AM
Subject: RE: [thelist] complicated sql


> Hey,
>
> > How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date,
> > and PHOTOS.photo_name?  I had this:
>
> I would have written your Sql query a little bit different. May help..
>
> SQLQuery = "select b.band_name, s.show_date, p.photo_name from showinfo s,
> bands b, photos p where b.band_id = p.photo_bandid and s.band_id =
b.band_id
> Order by s.show_date"
>
> Let us know,
>
> Rob
>
> p.s. if this doesn't work, you may want to check your primary/foreign
keys,
> also the data itself.
> -- 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>