January 28th, 2004, 01:32 PM
|
|
Junior Member
|
|
Join Date: Jan 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Problem building query to get correct results
I am working with a database with 4 tables. tblPCName, tblPatch1, tblPatch2, tblExcluded. I already know how to exclude pcnames in tblExcluded. What I am trying write a query to find the pcname from the tblPCName that matches the pcname from tblPatch1 or tblPatch2. I don’t know how to do this. I keep getting just the names that are in both tblPatch1 and tblPatch2. All of the tables have the common field pcname.
I also need to know how to eliminate the duplicates that may be in tblPatch1 and tblPatch2. All I need to know for this report are the pcnames that need to be patched not which patch they don't have.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
