Hi
Should you help me please?
I have one problem with select query. I made three tables as shown below. I need to do something like nested select. But it is not supported. How should I maintain the gain from database build with respect to data integrity?
A
--------------------
id int (pk)...
Hi
Please help me with MySQL!
I need to query something like this:
SELECT * FROM a WHERE NOT id IN ( SELECT a FROM c WHERE b = {x} )
While:
A
--------------------
id int (pk)
name char
B
----------------------
id int (pk)
name char
C
--------------------
id int (pk)
a int ref a
b int ref...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.