<> 在ORACLE的XML中的意思

今天上班的时候遇到了XML中·这么一句SQL
百度半天百度不到,后来问了下同事才知道原来 <> 是 != 的意思
就是t1.status <> '03' 的意思是 t1.status != '03'
SELECT
t1.ORDER_ID,
t1.BLN,
t1.CTNNO,
t1.SEALNO,
t2.TRUCK_LICENSE,
t2.DRIVER_NAME,
t2.DRIVER_MOBILE
FROM
T_TP_TRUCK_ORDER t1
JOIN T_TP_FREIGHT_ORDER t2 ON t1.ORDER_ID = t2.ENTRUST_ORDER_ID
WHERE
where t1.Carr_Shop_Name = #{carrShopName}
AND t1.STATUS <> '03'

posted @ 2021-01-12 15:23  RHsama  阅读(549)  评论(0)    收藏  举报