I have ONE table.
I have fields in the table for software name, and in the same software table it shows who has this software (non realtional I know), i.e. user1, user2, user3 which yes/no boolean values.
The app may have more than one user associated with on app, so user 1 and user 2 may have the same app.
I need a report to group by the users and their software:
select 'User1', softwarename
where user1 <> 0
select 'User2', softwarename
where user2 <> 0
select 'User3', softwarename
where user3 <> 0
ProductID --> Primary key
ProductName --> name of software
User1 --> yes/no
Here is an example of the records in the table:
Access 97, yes, yes, no
Word2000, no, yes, yes.
Excel2000, yes, no,yes
The desired use is to to have a list by user of what software they have.
The desired output for the querie would be grouped by user ideally.