Could somebody correct this join query?

Question

SELECT * 
FROM {$dbp}auctions au, ic.imgurl 
LEFT JOIN {$dbp}cache ic ON au.cache_id = ic.id

I'm baffled on where to set the alias for the second table (ic) and still only select the one column (imgurl).

Answer 1

"SELECT au.*, ic.imgurl FROM {$dbp}auctions au  
LEFT JOIN {$dbp}cache ic ON au.cache_id = ic.id" 

I think this is close to what you want. Your original query is selecting everything.