Re: Find records that don't exist in MySQl 4.0

2005-04-28 Thread Daniel Kasak
Andrew Hargreaves wrote: > In MySQL 4.0, is it possible to find all records that don't exist in one >query. I managed to do it in Access by referencing a query that I had >previously created, but I was wondering if it was possible to do this in one >step. > > Not in one step, no. If you're still

Find records that don't exist in MySQl 4.0

2005-04-28 Thread Andrew Hargreaves
In MySQL 4.0, is it possible to find all records that don't exist in one query. I managed to do it in Access by referencing a query that I had previously created, but I was wondering if it was possible to do this in one step. SELECT C.CustomerID, ([JobStatus]="0" And [JobTypeID]=2) AS KountNA, Co