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.
where customer.primarykey = PaymentInfo.UserID and
customer.primarykey= PersonalInfo.UserID and
Link_Payment.SubscriptionID= Customer_Subscription.primaryKey and
First_Name like 'john%'