Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Support MySQL data integrity?
Rycamor: Thank you man... But It is impossible to do it with JOIN! I spend a lot of time with JOIN without ANY success... But the TEMP tables should do it right! Thank you. Peters Jazz: Well... The "x " in my query should be 1 for Dylan from table B. So I want to get 2 & 3 (John &... -
Support MySQL data integrity?
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)... -
MySQL nested selects
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...
