Better:
select * from table as t1
left join table as t2 on t1.study=t2.study and not
t2.keyword ='K2'
where
t1.keyword = 'K1'
Santino
At 23:23 +0100 8-11-2004, Santino wrote:
Something like:
select * from table as t1, table as t2 where
t1.study=t2.study and
t1.keyword = 'K1' and not
t2.keyword ='K2'
Santino
At 11:57 -0800 8-11-2004, L a n a wrote:
Hello,
I've had a problem:
statement SELECT data_id from table WHERE keyword = a NOT keyword
= b returns SQL error
I've got the following not working solutions to my problem:
SELECT data_id FROM table WHERE keyword = a AND keyword (or !=) b
SELECT data_id FROM table WHERE keyword = a AND NOT (or OR NOT) keyword = b
To explain better what result I need to get, there is table
Id Study keyword
1 AK1
2 AK2
3 BK1
4 BK2
5 CK1
6 Ck3
I need to return study C, because it has only K1 keyword. However,
all the suggested solutions return me A, B, C in the following
order:
if I ask for K1/K2 then it returns studies A, B;
if I ask for K2/K1 (order matters) then it returns A, B, C.
How to solve the problem?
I tried SELECT T.data_id from table T WHERE T.keyword = a EXCEPT
SELECT T2.data_id from table T2 WHERE T2.keyword =b . But it gives
SQL error.
Any thoughts?
Thank you,
Lana
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
