[thelist] complicated sql

Ken Schaefer ken at adOpenStatic.com
Mon Dec 8 21:19:07 CST 2003


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Joel D Canfield" <joel at spinhead.com>
Subject: RE: [thelist] complicated sql


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

You need a join:
...
<snip>
...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

...actually, what the OP needs to do is post some sample data, and what the
expected output should look like! Otherwise, since there is no logically
obvious relationship between the data in question, I think we're all just
trying to make educated guesses as to what the output should look like.

Cheers
Ken

Microsoft MVP - Windows Server (IIS)



More information about the thelist mailing list