Using two table write the query for inner join and full join

See more:

SQL-Server

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.