展现一下今天写的两条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写到想吐了!!!!!!!!!!!!!!!!!!!!!!

展现一下今天写的两条SQL语句》上有8个想法

  1. Pingback引用通告: amoxil 500mg

  2. Pingback引用通告: generic albuterol inhaler

  3. Pingback引用通告: generic viagra fast shipping

  4. Pingback引用通告: generic cialis tadalafil 20mg

  5. Pingback引用通告: buy ciprofloxacin

  6. Pingback引用通告: naltrexone generic brand

  7. Pingback引用通告: viagra brand

  8. Pingback引用通告: buy chloroquine

发表评论

电子邮件地址不会被公开。 必填项已用*标注