展现一下今天写的两条SQL语句

SELECT `strb_prod_id` as ProdId, `goods_id`, `goods_name`, `goods_number`, `market_price` FROM `qx_good_strb_stock` q,`ecs_goods` g WHERE g.is_on_sale=1 and q.qx_good_id=g.goods_id;
SELECT g.`goods_id`, g.`goods_name`, g.`shop_price`, q.`SellingPrice` FROM `ecs_goods` g, `qx_out_goods_data` q WHERE q.shuai=1 AND q.qx_good_id=g.goods_id;

悲哀呀,最近写SQL写到想吐了!!!!!!!!!!!!!!!!!!!!!!