Reply to thread

Message: <blockquote data-quote="hirushan" data-source="post: 13043487" data-attributes="member: 31863">[CODE]CREATE TABLE table1(billno int,billinfo varchar(50))CREATE TABLE table2(billno int,billinfo varchar(50))CREATE TABLE table3(billno int,billinfo varchar(50))--3 TablesInsert into table1 values (1111,'Marie')Insert into table2 values (1111,'Marie')Insert into table3 values (1111,'Marie')--Only 2 TablesInsert into table1 values (1112,'Hirushan')Insert into table2 values (1112,'Hirushan')--Only 1 Insert into table1 values (1113,'Eranga')select * from table1select * from table2select * from table3--All 3select table1.billno as [table1-BillNo],       table1.billinfo as [table1-BillInfo],       table2.billinfo as [table2-BillInfo],       table3.billinfo as [table3-BillInfo] from table1INNER JOIN table2     ON table1.billno=table2.billnoINNER JOIN table3    ON table1.billno=table3.billno--2 onlyselect table1.billno as [table1-BillNo],       table1.billinfo as [table1-BillInfo],       table2.billinfo as [table2-BillInfo],       table3.billinfo as [table3-BillInfo] from table1INNER JOIN table2     ON table1.billno=table2.billnoLEFT JOIN table3    ON table1.billno=table3.billno--only 1select table1.billno as [table1-BillNo],       table1.billinfo as [table1-BillInfo],       table2.billinfo as [table2-BillInfo],       table3.billinfo as [table3-BillInfo] from table1LEFT JOIN table2     ON table1.billno=table2.billnoLEFT JOIN table3    ON table1.billno=table3.billno[/CODE]</blockquote>

Verification: Awruddata maasa keeyada?

Top Bottom