We have been using SQL Server 2014 for our project as a backend source. We have been performing various joins on the tables. We came across a question in one to many and many to one relationship in joins.
Say for example: I have a table named Industry and another table called Products. Industry holds the list of Industry in market and Products holds that industry's multiple products.
Id IndustryName Owner
Id IndustryId ProductId ProductName
From the above tables, I am performing two queries as shown below:
1 to many
Select * from Industry inner join Products on Industry.Id = Product.IndustryId
many to 1
Select * from Product inner join Industry on Product.IndustryId = Industry.Id
Among the above which will be more efficient performance wise?