How to make join query in sql server( for beginners)

  1. Open SSMS.
  2. Expand your Database.
  3. Right click on views under that Database and then click on New view.



  4. Select the tables that you want to join and click on Add.



  5. Join the columns (PK and FK) in tables. It can be done through drawing the line from one column(PK) of table to another column(FK) of table.

  6. Select the columns you want to select from tables.



  7. You can view the query in below preview field.
  8. Copy your query and paste it in your code.

Thanks for viewing waiting for your positive response