Re: SQL help

What about

WITH temp AS (SELECT cont.b1, cont.c1, occu.c1 
                       FROM cont, occu
                       WHERE cont.c1=occu.c1)
SELECT bus.b1 FROM bus
WHERE bus.bi NOT IN(SELECT cont.b1 
                                   FROM temp)


Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 8-2-2007 at 14:35 Bob Bledsoe wrote:

I have 3 files, BUS, CONT, OCCU. BUS is tied to CONT by field b1 and there

can be more the one record in CONT for each record in BUS. CONT is tied to

OCCU by field C1. What I am trying to get is all the records ib BUSS that

have NO record in OCCU. I'm totally lost as to how to do this with SQL.