Pooja Chowdhury

Pooja Chowdhury

  • NA
  • 396
  • 39.8k

need output from these two tables

May 30 2018 1:06 AM
i have two tables with values
  1. create table tb11  
  2. (  
  3. SignalID varchar(max),  
  4. ZID varchar(max),  
  5. EmailID varchar(max)  
  6. )  
SignalID ZID EmailID
123733 128424 [email protected]
123733 128425 [email protected]
123425 128426 [email protected]
 
  1. create table tb12  
  2. (  
  3. CreateID varchar(max),  
  4. SignalID varchar(max),  
  5. ZID varchar(max)  
  6. )  
CreateID SignalID ZID
706063 123425 128424, 128425, 128426
706063 123733 128424, 128425, 128426
706064 123733 128424
706065 123733 128425
706066 123733 128426
 
i need the output from these two tables of the following table
 
SignalID CreateID EmailID
123425 706063 [email protected]
123733 706063 [email protected]
123733 706063 [email protected]
123733 706064 [email protected]
123733 706065 [email protected]
123733 706066 [email protected]
 

Answers (5)