SQL select not giving results wanted

[jgeddes]

Here is my select statement:

select STOCK,INVAMT,MAKE,VID,MODEL,ENGINFO,TTYPE,CHAVAIL,PRDCLS,STATUS,EUSER,SLSNO from NDTABLES.CHASSISDB WHERE MAKE='MACK' OR MAKE='VOLVO' AND PRDCLS='RO' ORDER BY STOCK

Currently, it gives me only MACK and VOLVO, but I get any and all records for PRDCLS.??!?!?!

Why?

Thanks...

John

 

[karluk]

You are probably having a problem with the precedence of AND over OR. Try using parentheses:

select STOCK,INVAMT,MAKE,VID,MODEL,ENGINFO,TTYPE,CHAVAIL,PRDCLS,STATUS,EUSER,SLSNO from NDTABLES.CHASSISDB WHERE (MAKE='MACK' OR MAKE='VOLVO') AND PRDCLS='RO' ORDER BY STOCK

 

[jgeddes]

karluk

That would work, but I guess what I did not explain fully is I am using SQL inside another application and I am letting the user select predicates dynamically.

I did get it to work perfectly using IN instead of =.


Thanks for the help.

John