阅读背景:

如何显示一个非空值,然后显示所有空值

来源:互联网 

Hello I have a mysql query

你好我有一个mysql查询

SELECT 
    unicitem,
    unicreplacement,
    sc_products.productID,
    sc_products.brief_description_ru,
    sc_products.name_ru,
    price.postavchik as suupplier,
    sc_group_discounts.`action`,
    sc_group_discounts.procent,
    price.Price as Price,
    price.in_stock,
    price.supplier
FROM sc_products
LEFT OUTER JOIN t26_replaceable_items ON (sc_products.unic = t26_replaceable_items.unicreplacement)
LEFT OUTER JOIN sc_group_discounts ON (sc_products.item_group = sc_group_discounts.item_group)
LEFT JOIN price ON (t26_replaceable_items.unicreplacement = price.unic) AND (sc_products.suupplier=price.postavchik)     
WHERE t26_replaceable_items.unicitem = '0092S40050'
GROUP BY productID
ORDER by isnull (price.Price),price.Price ASC
S



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: