[Cialug] SQL Query

[Bailey, Jonathan C]

Is there something I'm missing here?

select * from workorders where (Customer=3D1 or Customer=3D2 or =
Customer=3D3 or Customer=3D7 or Customer=3D9) and (Priority=3D'E' or =
Priority=3D'A') and (Status=3D'O' or Status=3D'C') and =
(Assignment=3D'0001' or Assignment=3D'0002') and select * from =
workorders where (Customer=3D1 or Customer=3D2 or Customer=3D3 or =
Customer=3D7 or Customer=3D9) and (Priority=3D'E' or Priority=3D'A') and =
(Status=3D'O' or Status=3D'C') and (Assignment=3D'0001' or =
Assignment=3D'0002');=20


#1064 - You have an error in your SQL syntax.  Check the manual that =
corresponds to your MySQL server version for the right syntax to use =
near 'select * from workorders where (Customer=3D1 or Customer=3D2 or =
Cus=20






--------------------
Jonathan Bailey
POS Analyst
bailj0@bp.com
(515) 226-5005