View Single Post
  #6 (permalink)  
Old March 21st, 2007, 12:04 PM
pallone pallone is offline
Friend of Wrox
Points: 1,243, Level: 13
Points: 1,243, Level: 13 Points: 1,243, Level: 13 Points: 1,243, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2003
Location: , , United Kingdom.
Posts: 290
Thanks: 24
Thanked 0 Times in 0 Posts
Default

Just to clarify a bit more. If you have a look at the tables above you will see that the third table (CompanyCompare) will have two records repeated:

 2 | 104 | Aimor sp | 10000 |
+------------+----------+------------+-----------------------+
| 2 | 104 | Aimor | 10000

This is because 'Aimor sp' is not exact 'Aimor' but they are similar. So I will have to insert both records in my CompanyCompare table.

Hope this helps

Cheers
Reply With Quote