Itgirl16
asked on
inner join of 4 table
I am trying to do innner join of 4 table and in my table there is only 2 record but I am doing something wrong in neer join it's repeating and getting total 4 record with saem repeating value.
please help me out with this.
select
customer.Member_Status
select customer.First_Name
from Link_Payment,Customer,Paym ent_Info,P ersonalInf o,Customer _Subscript ion
where customer.primarykey = PaymentInfo.UserID and
customer.primarykey= PersonalInfo.UserID and
Link_Payment.SubscriptionI D= Customer_Subscription.prim aryKey and
First_Name like 'john%'
please help me out with this.
select
customer.Member_Status
select customer.First_Name
from Link_Payment,Customer,Paym
where customer.primarykey = PaymentInfo.UserID and
customer.primarykey= PersonalInfo.UserID and
Link_Payment.SubscriptionI
First_Name like 'john%'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.