mysql 查询语句错误，求大神帮解

[济初]

SELECT
(g.goods_id, c.cat_name, g.goods_sn, g.goods_name, b.brand_name, g.goods_number, g.market_price, g.shop_price, g.promote_price, z.zp_price, z.is_recommend)
FROM
(`shdj`.`shdj_zpgoods` AS z ,`shdj`.`shdj_goods` AS g )
LEFT JOIN
`shdj`.`shdj_brand` AS b ON g.brand_id = b.brand_id
LEFT JOIN
`shdj`.`shdj_category` AS c ON z.cat_id = c.cat_id
WHERE g.goods_id = '260' AND g.goods_id = z.goods_id


错误提示Operand should contain 1 column(s)

[一起混吧]

贴出完整的错误信息以供分析

[Dleno]

(g.goods_id, c.cat_name, g.goods_sn, g.goods_name, b.brand_name, g.goods_number, g.market_price, g.shop_price, g.promote_price, z.zp_price, z.is_recommend) 查询列名去掉括号

[ayzen1988]

//按你上面的写法我猜的，不知道是否符合你的要求
SELECT
	a.*,
	c.cat_name,
	b.brand_name
FROM
	(
		SELECT
			g.goods_id,
			g.goods_sn,
			g.goods_name,
			g.goods_number,
			g.market_price,
			g.shop_price,
			g.promote_price,
			z.zp_price,
			z.is_recommend,
			g.brand_id,
			z.cat_id
		FROM
			`shdj`.`shdj_zpgoods` AS z,
			`shdj`.`shdj_goods` AS g
		WHERE
			g.goods_id = '260'
		AND g.goods_id = z.goods_id
	) a
LEFT JOIN `shdj`.`shdj_brand` AS b ON a.brand_id = b.brand_id
LEFT JOIN `shdj`.`shdj_category` AS c ON a.cat_id = c.cat_id;