Select All?

[nikko50]

Hi there.
I want to select all from one table and just one item from another table. If I try to do the below it won't work. How can I do this?

SELECT * , buyers.buyer
LEFT JOIN buyers ON buyers.id = equipment.buyer
FROM equipment

[tomhath]

SELECT equipment.* , buyers.buyer
FROM equipment
LEFT JOIN buyers
ON buyers.id = equipment.buyer