Join Table 1 with Table 2 and the Table 2 has two foreign key column in each raw
Posted By: Anonymous I have two Tables as given below – I would like to write a SQL query (SQL server Database) to get the data in Result table format. Please help me to write the SQL query which is follows the best practice rule. Solution Join table2 simply twice SELECT Pincode,t2.Lcationname,t3.Lcationname FROM Table1 t1 …