Start Free Trial

asked on

need to list all software product names and versions with their current status

Hi, I have 2 tables and need to list all software product names and versions with their current status.

Software table

Name Version
Tax 1988
Tax 1999
Tax 2010

SoftwareBuild Table
Version CompID ComponentName BuildStatus
1998 1 Keyboard Driver Ready
1998 3 Dbase Interface Ready
1999 1 Keyboard Driver Ready
1999 4 Dbase Interface Ready
1999 6 Pen Driver Usable
2010 1 Keyboard Driver Ready
2010 2 Touch Screen Driver Ready
2010 5 Chart Genertor Null

So the output should be like the following

Name version status
Tax 1998 Ready
Tax 1999 Usable (since one of the component status is usable)
Tax 2010 No Ready (since one of the component status is null)

Thanks

What software are you doing this in?

Without the software name in the build table, this makes no sense. Consider

Name Version
Tax 1988
Tax 1999
Tax 2010
Exce 2010

...

ASKER

I am using SQL Server. OK I will add the software name to the build table but I still get stuck.

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

slightwv (䄆 Netminder)

@Scott:

Cleaner than mine! That's what I wanted to do but my mind is already in Thanksgiving mode!

Thanks!

Yeah, we can leave in 30 minutes today ... but we have to work on Fri. Not a big deal to me at all. Many others just take the day off.

ASKER

Thank you so much Slightwv and Scott.