Page 1 of 1

select on 2 db

Posted: Sun Jun 20, 2004 7:50 am
by pelegk2
i havee this select :

Code: Select all

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

Posted: Sun Jun 20, 2004 9:59 am
by Buddha443556
Might try something like this:

Code: Select all

SELECT * FROM orangedelivery AS orange, othertable AS other WHERE orange.region=106 AND orange.workers_number = other.workers_id
Provided all orange worker_number have a corresponding other worker_id. If not then an outer join maybe needed.

Code: Select all

SELECT * FROM orangedelivery AS orange LEFT JOIN othertable AS other ON  orange.workers_number = other.workers_id WHERE orange.region=106
Hope that helps.

Posted: Mon Jun 21, 2004 1:53 am
by pelegk2
10X:) alot i will try it