Condition in joins

Question

Hi In one SP if same table need to perform as left join and inner join to another table based on some condition.. If possible ...Please let me know ... Thanks in advance Sathish

sathish · Answer

nilesh you are right.. but for me it should be if(a==2) table1 INNER JOIN table2 else table1 LEFT JOIN table2 Let me know like this any condition possible !!

Nilesh Avhad · Answer

Hi Try this sql query and and change the table name as per your tables names SELECT * FROM ( table1 INNER JOIN table2 ON table1 .PK KEY = table2 .FK KEY ) LEFT JOIN table3 ON table2 .PK KEY = table3 .FK YKEY