Member Avatar for whiteyoh

Hi All,

In my php script i need to concatenate 4 tables from a foreign key of dev_id. It will be a select *. I know, for example that 4 tables have a value of dev_id=115, but when i run the script it gets no results.

here is my attempt (I do post mysql stuff in that forum, but never get any answers.)

SELECT * FROM tbl_dev_dilligence, tbl_dev_dilligence_business, tbl_dev_dilligence_director WHERE tbl_dev_dilligence.dev_id = '115' AND tbl_dev_dilligence.dev_id = '115' AND tbl_dev_dilligence_director.dev_id = '115'

  • 2 Contributors
  • 1 Reply
  • 58 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by saiprem
Member Avatar for saiprem

Check your query once again, why are you using where condition 2 times

SELECT * FROM tbl_dev_dilligence,
tbl_dev_dilligence_business,
tbl_dev_dilligence_director

WHERE

tbl_dev_dilligence.dev_id = '115' AND
tbl_dev_dilligence.dev_id = '115' AND

tbl_dev_dilligence_director.dev_id = '115'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.