![Sad :sad:](./images/smilies/sad.gif)
![Scratch :scratch:](./images/smilies/scratch.gif)
Have table1 with
filed1
3500
4500
1458
...
and tabl2 with
filed2 field3
3500 description of 3500
4500 description of 4500
1458 description of 1458
...
i need a query to get value of filed3 from value filed1 and return the recordset similar 3500-description of 3500....
peraph with join statement?
note:
the tables are into the same db