Click here to Skip to main content
15,918,193 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Customer table as follows


Custid Firstname Lastname email address city

1 Ram Kumar ramkumar@gmail.com VernonHwy Chennai
2 Rajesh Kannan rajesh@gmail.com Hancock Chennai
3 Thomas Jaffer thomas@gmail.com Constitution Chennai
4 Paul Adams paul@gmail.com James Chennai
5 James Maddison maddison@gmail.com Hancock Chennai


Order table as follows

Orderid Orderdate Amount Customerid

1 07/04/2014 234 1
2 03/14/2015 79 3
3 05/23/2016 124 2
4 09/03/2017 66 3


From using above customer and order table i want to write the query for INNER JOIN and FULL JOIN and Get the output.


for that how can i write the query.

What I have tried:

Customer table as follows


Custid Firstname Lastname email address city

1 Ram Kumar ramkumar@gmail.com VernonHwy Chennai
2 Rajesh Kannan rajesh@gmail.com Hancock Chennai
3 Thomas Jaffer thomas@gmail.com Constitution Chennai
4 Paul Adams paul@gmail.com James Chennai
5 James Maddison maddison@gmail.com Hancock Chennai


Order table as follows

Orderid Orderdate Amount Customerid

1 07/04/2014 234 1
2 03/14/2015 79 3
3 05/23/2016 124 2
4 09/03/2017 66 3

From using above customer and order table i want to write the query for INNER JOIN and FULL JOIN and Get the output.


for that how can i write the query.
Posted
Updated 2-Mar-17 5:32am

1 solution

See SQL Joins[^].
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900