How do you connect tables in database?

Answer 1

using join operations.

for Eg: if you have to join two tables company table and location table using a primary key CompanyID in company table and foreign key CompanyID in location table then we can do this using equi-join as below:

SELECT *

FROM company c, location l

WHERE c.CompanyID = l.CompanyID

--->> the above query select all the companies with a location.

Note: Google out for for type of joins