natural full join code example

Example: Natural JOIn

salesman_id	city		customer_id	ord_no	purch_amt	ord_date	cust_name	grade	name		commission
5005		London		3001		70009	270.65		2012-09-10	Brad Guzan		Pit Alex	0.11
5001		New York	3002		70002	65.26		2012-10-05	Nick Rimando	100	James Hoog	0.15
5001		New York	3007		70005	2400.60		2012-07-27	Brad Davis	200	James Hoog	0.15
5001		New York	3002		70008	5760.00		2012-09-10	Nick Rimando	100	James Hoog	0.15
5006		Paris		3004		70010	1983.43		2012-10-10	Fabian Johnson	300	Mc Lyon		0.14
5001		New York	3002		70013	3045.60		2012-04-25	Nick Rimando	100	James Hoog	0.15

Tags:

Misc Example