For table relation

Even if you don't mark a column as Foreign Key, you can join 2 tables on the basis of any common column, Otherwise it is not possible, and you will endup with Cross Join as suggested by Vishal Joshi.

+5

Vishal Joshi4y ago

Without a foreign key column, you can directly add comma-separated table names which can give you data of both tables like the below sample:

select * from Product,ProductCategory where product.ProductId = 1

But, it will map sub-table data with all primary key rows like the below screen print.

Above example, we can see ProductId 1 is mapped with ProductCatId 1 and 2.

+6

Jaydeep Patil4y ago

https://launchschool.com/books/sql/read/table_relationships

+5

Rajanikant Hawaldar4y ago

https://www.c-sharpcorner.com/blogs/join-tables-without-foreign-key-in-sql-server

+5