SQL Server query

Accepted answer

Use UNION to concatenate rows.

Result:

Then skip the relationship and proceed with the next step

There is no relationship between this table.as asked my my interviewers.plz suggest me this,how is it possible

Hey

Use SQL Query Builder to create any type of query

Open SSMS -> Click New Query -> press CTRL + SHIFT + Q

Add your tables, make relationship between the tables, select your fields

All done!!

Good Luck