Re: SQL Question
From: Ayokunle Giwa <akgiwa_at_cnct.com>
Date: 1996/05/19
Message-ID: <4nnv2t$dhu_at_mars.cnct.com>#1/1
Date: 1996/05/19
Message-ID: <4nnv2t$dhu_at_mars.cnct.com>#1/1
Hi ......
I believe one way to solve the problem is to do an self-join
that will make sure that 'JOHN' appears in your result set. You can then add an
NVL(count(Tool),0) to make sure that you get a zero for his listing. You have 3 cols so
i think 2 joins are required i think the city and tool cols would do then specify your
where clause as the city in wherever and tool as whatever. You can fiddle with it but I
know this should help.
Received on Sun May 19 1996 - 00:00:00 CEST