w3resource logo


SQL join tables based on non-key column

rating Sql join tables based on nonkey column Average rating 7 out of 10. Total 13 users rated.



In this page we are discussing about such a join, where there is no relationship between two participating tables.


Sample table : despatch

Sample table : orders

To get 'des_num' and 'des_date' columns from the table 'despatch' and sum of 'ord_amount' column from the table 'orders' together after a joining, with following conditions -

1. 'a', and 'b' are the aliases of 'despatch' and 'orders',

2. 'ord_amount' of 'despatch' and 'orders' must be same,

3. the same combination of 'des_num' and 'des_date' of 'despatch' should be grouped,

the following sql statement can be used :

SELECT a.des_num,a.des_date,
FROM despatch a, orders b
WHERE a.ord_amount=b.ord_amount
GROUP BY a.des_num,a.des_date;


Sql join tables based on non-key column

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.


Rate this tutorial

Your Rating: not set

Share this tutorial

RSS Feed