Thats fine, but i need to extend it.PHP Code:$query = "SELECT * FROM `Student`";
The Students table has a field called 'Student_ID'
The Persons table has a field called 'Student_ID' (foreign key etc)
I want to select all the entries from the 'Student' table where the 'Student_ID' is not in the 'Persons' table
any help guys?




Reply With Quote