|
AdamWest
Constraint Violating Yak Guru
USA
302 Posts |
 Posted - 02/20/2013 : 09:18:40
|
I Have this simple query but get error message:
Msg 4145, Level 15, State 1, Line 5
An expression of non-boolean type specified in a context where a condition is expected, near 'ON'.
SELECT * FROM PTC.ORD_M_ORDER
WHERE ORDER_STATUS IN (4,7,8)
AND FACILITY_KEY = FacilityKey
AND RENEWED_FROM IS NULL
AND SIGNED ON >= FromDate and SIGNED_ON <= ThruDate;
|
|
Error in this query
