直接把case條件式寫在where後試試select * from 資料表A as A join 資料表B as B on A.no = B.no where (case when B.redate is null then.
確定! 回上一頁