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,sum(b.ord_amount) FROM despatch a, orders b WHERE a.ord_amount=b.ord_amount GROUP BY a.des_num,a.des_date;
Outputs of the said SQL statement shown here is taken by using Oracle Database 10g Express Edition
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.
Did you find this tutorial useful? If so, We’d love for you to share it with some friends JUST CLICK HERE to Tweet the post.
Please do let us know what you thought in the comment section below – We’d love to hear your feedback.