link id number to other table

[ratcateme]

i have two tables

one with logins and a file called domain_id

domain_id corresponds to the ID filed in another table.

i want to run a query that select the domain_id from the users table and then gets the domain name from the domains table.

 

Scott.

[fenway]

You need a JOIN:

 

select d.name from domains as d inner join logins as l using (domain_id) where l.username = <whatever>