omg thanks all

cp21 · Nov 17, 2015 1:11 PM

With small difference, http://sqlfiddle.com/#!6/433b6...

prankster · Nov 17, 2015 1:16 PM

Assuming you are looking for shipping address: Query 1: select concat(FirstName,' ',LastName) as customer_name, email, concat(Line1,' ',Line2, ' ',City,' ',State,' - ',ZipCode) as shipping_address, phone as phone_number from customer c left outer join address a on (c.CustomerID = a.CustomerID) and (c.ShippingAddressID = a.ShippingAddressID); Query 2: passing email as parameter. select concat(FirstName,' ',LastName) as customer_name, email, concat(Line1,' ',Line2, ' ',City,' ',State,' - ',ZipCode) as shipping_address, phone as phone_number from customer c left outer join address a on (c.CustomerID = a.CustomerID) and (c.ShippingAddressID = a.ShippingAddressID) where email = {pass_email}; Query 3: Using named query select concat(FirstName,' ',LastName) as customer_name, email, concat(Line1,' ',Line2, ' ',City,' ',State,' - ',ZipCode) as shipping_address, phone as phone_number from customer c left outer join address a on (c.CustomerID = a.CustomerID) and (c.ShippingAddressID = a.ShippingAddressID) where email = :email_id;

Ruben123 · Nov 17, 2015 5:43 PM