Re: LEFT Join Question

On Thu, Jan 25, 2007 at 06:51:34PM -0500, Rob V wrote:
> 
> I know I have to use a left join - but I can seem to figure out the syntax
> when dealing w/ different columns of the same table.

I haven't tested this to remind myself for sure that it will work,
but I think you ought to be able to RIGHT OUTER JOIN the table you
just LEFT JOINed to to the next table using a different column.

A
-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.    --Bruce Schneier