Help in logic statment in sql

ok but if i'm having NO_BOOKS less than 200 and NO_MAGZ is morthan 300 i need it to return either this or this but not morthan 200 for example this table

ID	NO_BOOKS	NO_MAGZ
33-01	200	0
33-02	146	0
33-03	0	400
33-04	0	200
33-05	500	67

see My query depend on the No_BOOKS and ignoring the NO_MAGZ

Unless the NO_BOOKS are 0 I should check the NO_MAGZ

so in the table above it should only retrun ID :

33-01

33-02

33-04

You got my point now :)

as per that, your query works fine at my side

It will display record in case either NO_BOOKs <=200 OR NO_MAGZ <=200


select * from tbl_BOOK_MAGZ

where NO_BOOKs <= 200 OR NO_MAGZ <= 200

When u get NO_MAGZ greater than 200 in output, condition for NO_BOOKs <=200 is satisfied, thats why u getting that output.

Your query is right as per your requirement.

Thanks... :)

a little confusion, please make me correct if i am wrong

assume this table as your output

id   NO_BOOKs   NO_MAGZ  
1       100            150
2       150            200
3       0               170
4       180            0


now, if NO_BOOKs = 210 and NO_MAGZ = 150, should it be consider it in output?

yes see I have one condition which make category depending of the section of (BOOKS & MAGAZIENS) so first category is morethan 500 ITEMS which will include morethan 500 item either books or magzines another category is less than or equal 200 ITEMS which will include less than 200 Items either books or magazines  that's why i need to check both either this or this has the condition
you got it now ?

it is because your NO_BOOKs <= 200 conditions becomes true, which might have NO_MAGZ >200, so you getting that output.

can u tell us What output do you want exactly?

hi,
   use 'AND' instead of 'OR'

select * from tbl_BOOK_MAGZ
where NO_BOOKs <= 200 AND NO_MAGZ <= 200

hope this helps :)