Posted by: prankster November 17, 2015
SQL statement help needed
Login in to Rate this Post:     0       ?        
Lets, see if you are trying to do following,
Customer_table
--------------------
Customer_Id | Customer_Name | Customer_City | Customer_State

Email_Id_table
------------------
Customer_Id | Customer_Email_Id

Select C.Customer_Id, C.Customer_Name, C.Customer_City, C.Customer_State, E.Customer_Email_id From Customer_table C Join Email_Id_talbe E on
C.Customer_Id = E.Customer_Id

Here is the sqlfiddle,
http://sqlfiddle.com/#!6/655f9/4
Read Full Discussion Thread for this article