Join a Table where the two columns need to be linked to single column in joined table
Hi,
I have the situation where I need to join a table where two columns within this table need to be linked to
the same column in the other (join) table. I use the following script below but it seems this does not
retrive the result sets i wanted. Can someone please help?
SELECT
t1.[PaymentID],
t1.[PaymentFrom], t2.[Client Name],
t1.[PaymentTo], t2.[Client Name]
FROM [Payments] t1 INNER JOIN [ClientDetails] t2
ON t1.[PaymentFrom] = t2.[ClienId] AND t1.[PaymentTo] = t2.[ClientId]