- Feb 15, 2003
- 2,437
- 1
- 0
I have two tables with data sorta like this
Table1
MO-XV
MO-VX
MO-SVTR
MO-UVUAQ
Table 2
MO-XV1
MO-VXajs
MO-SVTRUAQUZ
MO-UVAQ341
So basically what I need to do is see if the data in table 1 is in table 2. However, Table 1 has truncated data so actually I need to do something like this:
Select * from Table2 where Table2.Data like '(Select Table1.Data from Table1)%'
So in the above instance it should return all the data in Table 2.
Any ideas?
Table1
MO-XV
MO-VX
MO-SVTR
MO-UVUAQ
Table 2
MO-XV1
MO-VXajs
MO-SVTRUAQUZ
MO-UVAQ341
So basically what I need to do is see if the data in table 1 is in table 2. However, Table 1 has truncated data so actually I need to do something like this:
Select * from Table2 where Table2.Data like '(Select Table1.Data from Table1)%'
So in the above instance it should return all the data in Table 2.
Any ideas?