select on 2 db

[pelegk2]

i havee this select :

select  * from orangedelivery where region=106

in this orangedelivery table i have a col with the workes number!

in another table i have the workers id and there full name
how can i in the above select to get the worker's name?
thnaks in advance
peleg

[bubblenut]

select  orangedelivery.*, workers.name
from orangedelivery, workers 
where orangedelivery.worders_id=workers.workers_id && region=106

HTH
Bubble

[pelegk2]

i will try it it seems so simple