Re: Query question

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 27 May 2004 22:27:05 -0700
Message-ID: <1085722033.954451@yasure>

Mark wrote:

>>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

Well don't blame me that you posted a SQL statement with an error I wouldn't expect to see from someone with more than a few weeks of SQL coding under their belt. It was very reasonable to assume, especially given this is final's week, that you were a student trying to get someone else to bail you out.

I believe Andy has provided you with the solution.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri May 28 2004 - 00:27:05 CDT