I am trying to JOIN 3 Tables(table1, table2 & table3) in Mysql query where I want to pull the matching data from 2 tables(table1 & table2) comparing a Common Column existing in 3 tables(ie. 'PID').
When Joining these 3 tables, there is no data in table1 with the given Date('2012-12-27') then it's returning complete blank row.. Here, I want to get the matching data from the table2 matching the given Date and 'ZERO' or 'NULL' where there is no matching data in the other table ie. table1.. instead of a whole blank row.
Here is the Code I was trying that returns a complete BLANK ROW..
SELECT * FROM table3 b LEFT JOIN table1 r ON r.PID = b.PID LEFT JOIN table2 a ON ab.PID = b.PID WHERE b.Name ='stallion' AND r.Date = '2012-12-27' AND a.Date = '2012-12-27' ;