How to Fetch A Record If Shipping And billing Address are Different Show New Orders with Address If shipping and billing are different. I am stuck with this query. Can someone guide me a bit. Thanks
SELECT  t.TripId_PK, ls.name StartLocationName, le.name EndLocationName
FROM    trips t
JOIN    locations ls
ON      ls.LocationId_PK = t.StartLocationId_FK
JOIN    locations le
ON      le.LocationId_PK = t.EndLocationId_FK