Hi I was wondering if anyone could help me find the most efficient.. or
at least A efficient way to preform the following task:
I have a table that has some data, one of which is a UserName column. I
have another table that has multiple rows for that UserName. So table
one looks like:
id int
UserName varchar
StopTime datetime
and table two looks like
id int
UserName varchar
Group varchar
So far I have
SELECT table1.id
FROM table1, table2
WHERE table1.StopTime = 0 AND
table1.UserName = table2.username AND
table2.Group != 'Dedicated'
You can see that I am trying to get the id's from the first table where
the stoptime is 0 and they do NOT have an entry in table2 that says
dedicated. There are multiple entries is table2 for each username...
Any suggestions?
Thanks
Drew
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
