Posted by: SolveSQL November 17, 2015
Login in to Rate this Post:
0 
? 
?
Try this...
SELECT Name,City,State--,(add more cols as needed)
FROM ADDRESS a --(assuming thats your table name)
JOIN customer c ON a.customerid= c.customerid --(assuming customer is the table name and customerid is the common column)
WHERE c.emailaddress = 'abcde@abc.com' --(assuming emailaddress is the column that has email for the customer)
SELECT Name,City,State--,(add more cols as needed)
FROM ADDRESS a --(assuming thats your table name)
JOIN customer c ON a.customerid= c.customerid --(assuming customer is the table name and customerid is the common column)
WHERE c.emailaddress = 'abcde@abc.com' --(assuming emailaddress is the column that has email for the customer)
Last edited: 17-Nov-15 10:40 AM