Posted on: 2/18/2014 3:16:25 PM | Views : 570

I wanted to JOIN all the three tables and form one table for example if the Customer, Membership, and Personal_info table are Joined based on Cust_ID. and condition,Even if Customer(Cust_ID,Fname,Mname,Lname) exists and does not have a Membership(Cust_ID,Membership_Level) or Personal_Info(Cust_ID,Height,Weight,Dieases) should be shown in a table with NULL value.Here Cust_ID is a Primary Key in Customer Table and Foreign Key in Membership and Personal_Info. Go to the complete details ...