how to join three tables and select a particular field in one table

Question

Shivanand Arur · Answer

Select tbl1.ItemName tbl2.Item2Name tbl3.Item3name from Table1 tbl1 Inner Join Table2 tbl2 ON tbl1.UnqID = tbl2.tbl1_UNQ_ID Inner Join Table3 tbl3 ON tbl1.UnqID = tbl3.tbl1_UNQ_ID The joining criteria depends upon your table structure... Now in the example given above I have the Table1's Unique ID in the other 2 tables as its foreign key. Example: Table1 tb1_unq_id tbl1_Data 01 Data1 02 Data2 Table2 tb2_unq_id tbl2_Data tb1_unq_id(Foreign Key) 100 Data1 101 101 Data2 202 Table3 tb3_unq_id tbl3_Data tb1_unq_id(Foreign Key) 1001 Data1 101 1002 Data2 201 Please mark the Answer as ACCEPTED if it helped

Dorababu Meka · Answer

select tbl1. unitprice tbl2. itemname tbl3. vegdetails from table1 tbl1 table2 tbl2table3 tbl3 where tbl1.ID=your ID and tbl2.ID=tbl1.ID and tbl3.ID=tbl1.ID. where table1 table2 and table3 are your required tables

selvi subramanian · Answer

unit price from veg details (table1) itemname from ordered details (table2) n veg details pon from pon (table3) details

Dorababu Meka · Answer

Can you post some fields of your tables and tell what you want to display

how to join three tables and select a particular field in one table using sqlserver