bruce wrote:
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!
select
t1.*
from
tbl t1
left join
tbl t2
on
t1.id = t2.id
where
t2.id is NULL &&
t2.action = 1
I *think*.
--
John C. Nichel IV
Programmer/System Admin
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]