LEFT JOIN for noobs

[eluser]slowgary[/eluser]
Hi guys,

I have a query that left joins a few tables on the primary id, but when I get the results back the id field is duplicated (because it's in each table).

So my results look like this:

Code:

prod_id  |  prod_price  | prod_sku  |  prod_id  |  prod_image  |  prod_id  |  prod_stock

This works fine when all fields have data in them, but when the last table returns NULL as the prod_id, my code gets that one, which breaks everything.

Is there a way to only get back one prod_id field? Preferably from the first table. Thanks.