[chop] > How do I write a query to retrieve BANDS.band_name, > SHOWINFO.show_date, and > PHOTOS.photo_name? I had this: [chop] I'm no SQL expert but ...how about... select s.show_date,b.band_name,p.photo_name from showinfo as s inner join bands as b on (b.band_id = s.band_id) inner join photos as p on (p.photo_bandid = s.band_id) order by s.show_date HTH Rich