SELECT tools.toolid, tools.toolname, equipment.roomid
FROM tools LEFT OUTER JOIN equipment ON tools.equipmentid = equipment.equipmentid
WHERE roomid = %roomid

SELECT tools.toolid, tools.toolname, equipment.roomid
FROM tools, equipment 
WHERE tools.equipmentid *= equipment.equipmentid 
  AND roomid = %roomid

SB>3. Вообще делает ли кто нибудь так???? )))