9
Answers

Help in logic statment in sql

Photo of ToBe

ToBe

11y
1.6k
1
hi

I have this query

select * from tbl_BOOK_MAGZ

where NO_BOOKs <= 200 OR NO_MAGZ <= 200

when I'm runing this query It wil work only for the first part "where NO_BOOKs <= 200"

but it will not work in the other part "OR NO_MAGZ <= 200" it will give me also the NO_MAGZ which is even >200

can you help on that ??

Answers (9)