combining 2 tables based on productcode that apears inside text in one of the tables
My problem is as follows:
I've got 2 tables:
One table with the orders:
ID
field 2
description
1
xx
bla bla x1 bla
2
yy
bla y2
3
zz
x1
4
aa
x1bla
5
bb
bla bla
and one with productspecifications:
ID
Product
Specification
Discount
p1
x1
dfdf
5%
p2
x2
ghrr
-
p3
y1
tttt
3%
p4
y2
fgd
0
p5
z1
yuu
0
The problem is that I want the 'Specification' en 'Discount' to be matched with the orders, based on the discription in the order table. In the discription the product will sometimes appear inside text. How can this be done?