Advanced Select

[timgerr]

Hey all I have a select question that I need help on. Here is what I have. I have 3 columns that contain
|---|----------------|-------------|
|id | ComputerName | Software |
------------------------------------

Here is some data from select * from tbl_compair;

 1      MIAA01-047       Adobe Flash Player ActiveX                                       
 2      MIAA01-047       Adobe Reader 8.1.0                                               
 3      MIAA01-047       ATI Display Driver                                               
 4      MIAA01-047       Autodesk DWF Viewer 6.5                                          
 5      MIAA01-047       Citrix ICA Web Client  
 234    MIAA01-DORRANPS  Hummingbird Exceed 10                                            
 235    MIAA01-DORRANPS  Internet Explorer Q903235                                        
 236    MIAA01-DORRANPS  LANDesk Advance Agent                                            
 237    MIAA01-DORRANPS  LANDesk(R) Antivirus                                             
 238    MIAA01-DORRANPS  LANDesk(R) Common Base Agent 8    
 455    MIYS02-HARLELL   LiveUpdate 3.1 (Symantec)                            
 456    MIYS02-HARLELL   Macromedia Shockwave Player                                      
 457    MIYS02-HARLELL   MATLAB R2006a                                                    
 458    MIYS02-HARLELL   MetaFrame Presentation Server Web Client for Win32

So what we have is 3 Computer Names and software that is installed on them (this is a small part of all the returned data). I have to find out what software is different between all 3 computers. I need to know what is NOT installed on all 3 computers. Can this be done? If it can, I need help.

THank in advanace,
-T


-How important does a person have to be before they are considered assassinated instead of just murdered?
-Need more cow bell!!!

 

[SQLSister]

So do you have a list of all software somewhere?

If none have software installed it won't be in the table you currently have.

If you do have a list of all possible software ,then left join from that table to this one and selct where softwarename is null. Of course since you have names not ids, you may have to fool around with one s that are nto exact matches. For instance are Access, Access v2, Access version 2, Access 2005 all matches for Access or do you want to match ethe exact version numbers as well. Aslo are these names hand entered somewhere, then you will have varaiation in how they are entered such as SQL Server and Microsoft SQL Server.


"NOTHING is more important in a database than integrity." ESquared