[thelist] complicated sql

[Comitque]

Hey everyone, I have a complicated SQL query but I can't produce the results
that I want...

I have three tables.  it looks something like this:
(the site is for a venue/club)

BANDS
band_id | band_name

SHOW INFO
show_id | show_date | band_id (same id as the bands.band_id)

PHOTOS
photo_id | photo_name | photo_bandid (same id as the bands.band_id)

How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date, and
PHOTOS.photo_name?  I had this:

SQLQuery = "select * from showinfo, bands, photos where (bands.band_id =
photos.photo_bandid and showinfo.band_id = bands.band_id) order by
showinfo.show_date"

But that didn't quite work...

Any ideas what I'm doing wrong?  I'd really appreciate the help.

Thanks!