Ответ

kechinoff 23.01.2007 17:27

У вас в примере написано:

select b.id as id, b.title as title, ..., 
           m.title as marka,
           g.title as gear,
           ...
      from bulletin as b
 left join marka as m on b.marka_id = m.id
 left join gear as g on b.gear_id = g.id
 left join ...

Т.е. каждый параметр содержится в разной таблице.

Вот так я примерно думаю:

SELECT
	tbl_body.title as body_title,
	tbl_type.title as type_title,
	tbl_subcategory.title as subcategory_title
FROM 
	bulletin
JOIN LEFT param AS tbl_body ON bulletin.body = tbl_body.id
JOIN LEFT param AS tbl_type ON bulletin.type = tbl_type.id
JOIN LEFT param AS tbl_subcategory ON bulletin.subcategory = tbl_subcategory.id

Я правильно придумал?

---