Ysgrifennodd bruce:
hi...
i'm looking at what is probably a basic question.
i have a tbl with
-id
-action
-status
-date
ie:
id action status date
1 0 1
1 1 2
1 2 3
---------------------------------
2 0 4
2 2 5
i need a query to somehow get all id's that don't have an 'action=1', in
this case, id '2' would be the id that should be returned from the query...
however, i can't quite figure out how to create a query to select the items
that are the ones i'm looking for.
any help/thoughts would be appreciated!
thanks
-bruce
Hi Bruce,
Does this do it for you?
SELECT t1.id
FROM tbl t1
WHERE t1.id NOT IN (SELECT t2.id
FROM tbl t2
WHERE t2.id = 1)
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]