SQL help? Trying to join two queries.?

Question

I'm having an issue joining two queries(or unioning them) or maybe just making it one big query. I have: 
SELECT c.CustomerID, EmailAddress, LastName, FirstName, Line1 AS BillLine1, 
	Line2 AS BillLine2, City AS BillCity, State AS BillState, ZipCode AS BillZip
FROM Customers c JOIN Addresses ON c.BillingAddressID = Addresses.AddressID

SELECT b.CustomerID, EmailAddress, LastName, FirstName, Line1 AS ShipLine1, Line2 AS ShipLine2, City AS ShipCity, State AS ShipState, ZipCode AS ShipZip
FROM Customers b JOIN Addresses c ON b.ShippingAddressID = c.AddressID;

However, when I use union, it removes the columns from the second select statement that I need(shiplin1, shipline2, shipcity, shipstate, and shipzip).  How can I maintain these columns while adding them to the first query??

Jeff P · Accepted Answer

You need another JOIN. Join Addresses again (using a different name) and you can get the shipping address for each customer.

godfatherofsoul · Answer

Try adding constant placeholder values in the first query:

...,'No Shipping Address' AS ShipLine1,...

and in the 2nd query:

...,'No Billing Address' AS BillLine1,...

Trending News

SQL help? Trying to join two queries.?

2 Answers