Re: Query question

> This is classwork so you need to get this yourself rather than
> have one of us hand it to you. But basically ... the problem
> here is that you haven't even made it to the level of putting
> the resources required into the SQL statement.
>
> Start there ... then worry about the outer-joins, etc. later.

With all due respect, this is not classwork. I've been using SQL for over a decade now & have never come across a situation like this (as in approaching from the "wrong" side of an outer join to display values which don't have a join as well as those which do).

I admit that I did leave out one of the joins (to table C), but that's because it's actually unrequired in the example that I gave - hindsight editing of the post would have removed all references to it. I'm using a hardcoded value for the "c_id" column, rather than linking it to the C table.

Thanks

Mark Received on Sun May 23 2004 - 09:16:02 CDT