JOIN in SQL Data Manipulation Language

JOIN is a predicate in SQL's data manipulation language. This is primarily used in combining tables or relations to derive a new table.

We combine tables to create a query that will require information from more than one table.

Example of simple join query:

SELECT url.urlid, name, companyname
FROM url, company
WHERE url.urlid = company.companyurlid AND company.companyurldesc LIKE 'tayabas.ph'

I will post more on this topic later.