View Single Post
  #4 (permalink)  
Old March 21st, 2007, 10:39 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

The probably you got to use LIKE OPERATOR in this case. Still when you are uncertain that which of the tables will hold the subset of the other, this can't be the right solution. Let me still give you some idea on how it can be accomplished. Also I dont understand where does this COMPANY table fit into this... Do you have a separate table in that name?

_________________________
- Vijay G
Strive for Perfection
Reply With Quote