Left join of the same table but take 2 different columns .
Posted on 2014-01-24
i have a table A , with columns A.A,A.B,A.C,A.D . For each matching row in the table my query should give 2 rows one row with A.A as original and one row with A.B as original , how can i accomplish this .
1. A.A as original,A.C,A.D
2. A.B as original,A.C,A.D