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
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