Re: [development] SQL question.

Hi, Thanks, Gordon. On Thu, 2006-02-02 at 21:14 -0800, Earl Miles wrote:

Gordon Heydon wrote:

...

Hi,

I have been trying to work out a small sql issue, and I was wondering if someone might be able to help me.

Basically I have 2 tables and I was to do a left join and pull out all rows which has a value in the right hand table or doesn't exist.

eg.

SELECT a.a, a.b, b.a, b.c FROM a LEFT JOIN b ON a.a = b.a WHERE b.c = 'A';

So basically I want it to return.

a b a c 1 1 null null 2 2 2 A

etc.

Or do I need to 2 selects and merge them. When I do this now I get more of an inner join instead of a left join. I am not sure how I say "or doesn't exist".

Thanks in advance. Gordon.

...WHERE b.c = 'A' OR b.c IS NULL;

!DSPAM:1000,43e2e761150668362916074!