Sqlyog error 1452
I'm having problems with the foreign keys. I have a table DETAILS that
contains general details with the NAME being the primary key and another
table SYMTOMS with two columns NAME and SYM. I have tried to refernece
DETAILS to SYMPTOMS through NAME buy i get error 1452 Please help.
I tried setting foreign keys checks to 0. now the error doesnt occur but
what i want is this query to work
select SYM from DETAILS where NAME='a';
It doesnt work. it says details table doesnt have a col SYM but I have
linked them through foreign key.
DO i need to use apply JOIN. If yes,Please give the statement
No comments:
Post a Comment