[SOLVED] MYSQL JOIN QUERY

[Omzy]

ps_manufacturer table contains fields id_manufacturer and name

 

ps_manufacturer_lang table contains fields id_manufacturer and description

 

I need a join query that let's me extract name and description based on the id_manufacturer

 

Unfortunately I can't use 2 separate queries as the program I'm using won't let me do this, so everything needs to be one query.

[kickstart]

Hi

 

Here you go

 

SELECT `name`, `description`

FROM ps_manufacturer a

INNER JOIN ps_manufacturer_lang b

ON a.id_manufacturer = b.id_manufacturer

WHERE a.id_manufacturer = $SomeIdYouAreLookingFor

 

All the best

 

Keith

[Omzy]

thanks mate that has worked perfectly.