join 2 columns of a table with a column from another table

tnijenbrink · #1 (**permalink**) 01-17-10, 18:19

Hello,

I have got a table 'transport' with amongst others two columns:
transport.company_from
transport.company_to

And a table 'companies' that holds information about companies. For a list I need to extract the names of the companies in a set of records from the 'transport' table in a single query.

I have no idea how to go about this.

Anyone know?

r937 · #2 (**permalink**) 01-17-10, 19:03

Code:

SELECT transport.amongst
     , transport.others
     , from_co.name AS from_company
     , to_co.name AS to_company
  FROM transport
INNER
  JOIN companies AS from_co
    ON from_co.id = transport.company_from
INNER
  JOIN companies AS to_co
    ON to_co.id = transport.company_to

tnijenbrink · #3 (**permalink**) 01-18-10, 03:25

That worked, thanks a lot.

Internet Services

Web Development

Digital Marketing

Consumer Tech