SQL - slightly OT

I have some SQL which I am trying to get working Basically here is what I have: select * from tbl_meddelregos m, tbl_mdconfregoptions r where m.confregoptionid = r.confregoptionid and m.confregoptionid = 1 or m.confregoptionid = 6 or cocktailparty 0 order by lastname I keep on getting

Re: SQL - slightly OT

You need brackets around the ORs, otherwise it'll only join correctly on the first condition, and not the second two: SELECT * FROM tbl_meddelregos m, tbl_mdconfregoptions r WHERE m.confregoptionid = r.confregoptionid AND (m.confregoptionid = 1 OR m.confregoptionid = 6 OR cocktailparty

RE: SQL - slightly OT

by lastname Sandra Clark = http://www.shayna.com Training and Consulting in CSS and Accessibility Team Fusebox -Original Message- From: Pete [mailto:[EMAIL PROTECTED] Sent: Saturday, March 10, 2007 7:02 PM To: CF-Talk Subject: SQL - slightly OT I have some SQL which I am trying

RE: SQL - slightly OT

- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Sunday, 11 March 2007 10:03 AM To: CF-Talk Subject: Re: SQL - slightly OT You need brackets around the ORs, otherwise it'll only join correctly on the first condition, and not the second two: SELECT * FROM tbl_meddelregos m, tbl_mdconfregoptions r