MySQL complex join - Can't select multiple columns in second table
Computers:
----------
id, cond, type

Images:
-------
id, foreignid, name, width, height, def
	
SELECT
    id, cond, type,
    (SELECT name, width, height FROM images WHERE foreignid = computers.id ORDER BY def DESC LIMIT 1) AS image
FROM computers
	
Operand should contain 1 column(s)
	
select c.id, c.cond, c.type, i.name, i.width, i.height from computers c
left join images i on i.foreignid=c.id
order by i.def desc limit 1
	
computers left join images
	
computers right join images
	
computers inner join images
	
computer outer join images
	
SELECT comp.id, comp.cond, comp.type, img.name, img.height, img.width FROM computers comp left join image img on img.foreignid = comp.id