Problem reading from 3 tables in mysql
Posted
by user225269
on Stack Overflow
See other posts from Stack Overflow
or by user225269
Published on 2010-03-18T04:00:59Z
Indexed on
2010/03/18
4:11 UTC
Read the original article
Hit count: 352
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.
© Stack Overflow or respective owner
