Problem reading from 3 tables in mysql
- by user225269
What do I do, I need to fetch data from 3 tables in mysql, here is my current query. All of the tables contain the IDNO which has 03A45 number. But this query isnt returning any results:
SELECT *
FROM father, mother, parents
WHERE father.IDNO=mother.IDNO=parents.IDNO
AND mother.IDNO='03A45'
AND father.IDNO='03A45'
AND parents.IDNO='03A45'
What would be the correct query for this?
All of the tables have the IDNO as primary key.
