LOOK UP in query

[sal21]

First query of this type

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

[HansV]

Create a query like this:

SELECT table1.filed1, tabl2.filed3 FROM table1 LEFT JOIN tabl2 ON table1.filed1 = tabl2.filed2

[sal21]

Create a query like this:

SELECT table1.filed1, tabl2.filed3 FROM table1 LEFT JOIN tabl2 ON table1.filed1 = tabl2.filed2

no WORDS!