I have 2 table A & B link by ID as below. It is Oracle database. I use Toad to extract data. I just learn SQL and don't know T-SQL. I tried to write case statement but it doesn't work the way I want. These following case statement only display 1 email for a ID.
select distinct ID,
case when EMAIL_CODE = 'work' then
case when EMAIL_CODE = 'HOME' then
from TBL A where EMAIL_CODE in ( 'work' , 'home' )
group by ID,EMAIL_CODE, EMAIL_ADDRESS ) mail
where B.ID = mail.ID
I want to display them in 3 column as below:
Please help! Thank you in advance!
If 3 columns are static (meaning that no account has more than 2 email addresses then you can use the static PIVOT but in order to use it you first need to come up with the common data for all accounts. Row numbering partitioned by the ID would be a good choice. Here is the sample:
This will work if you have SQL Server 2005 or better.
Hope this helps,