w3resource logo


SQL WHERE CLAUSE PRIMAY AND FOREIGN KEY

SQL join two tables related by a single column primary key or foreign key pair using where clause

rating Average rating 7 out of 10. Total 149 users rated.

<<PreviousNext>>

Description

In this page we are going to discuss the usage of two or more tables in a joining with single column PRIMARY KEY and FOREIGN KEY.

Example

Sample table : foods

Sample table : company

To get 'item_name' and 'item_unit' from 'foods' table and 'company_name' and 'company_city' form 'company' table after a joining with following conditions-

1. 'company_id' is primary key in 'company' table,

2. 'company_id' is foreign key in 'foods' table which is referencing to the, primary key of 'company' table,

3. 'company_id' of 'company' and 'foods' must be same,

4. 'company_city' of 'company' column must be 'London',

the following sql statement can be used :

SELECT foods.item_name,foods.item_unit,
company.company_name, company.company_city
FROM foods ,company
WHERE  foods.company_id =company.company_id
AND company.company_city='London';

Output

Sql join two tables related by a single column primary key or foriegn key pair using where clause

Outputs of the said SQL statement shown here is taken by using Oracle Database 10g Express Edition.

See our Model Database

Here is a new document which is a collection of questions with short and simple answers, useful for learning SQL as well as for interviews.



<<PreviousNext>>