PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
SELECT ReportRef, (SELECT Answer from TableA where ItemID =1), (SELECT Answer from TableA where ItemID =2), (SELECT Answer from TableA where ItemID =3) FROM TABLEB Then join the ReportRef from TABLEB to TABLEA so that it doesn't return incorrect data based on each report. Where ReportType = 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Best book for Internet security||4||50|
|Sql does not recognize null value from Oracle source||8||23|
|How do I find out to see if there is any open transaction in DB2 database ?||2||31|
|Question on sending emails using SQL Server 2008 R2 database mail||10||54|
Join the community of 500,000 technology professionals and ask your questions.