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