RE: adding 3 values

2007-05-10 Thread Edward Kay
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 May 2007 10:08 To: mysql@lists.mysql.com Subject: adding 3 values Hi, I have 3 integer values in the table single_rooms, double_rooms, twin _ooms but want to add them all up to do a comparison

RE: adding 3 values

2007-05-10 Thread Edward Kay
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 May 2007 10:08 To: mysql@lists.mysql.com Subject: adding 3 values Hi, I have 3 integer values in the table single_rooms, double_rooms, twin _ooms but want to add them all up to do a

Re: adding 3 values

2007-05-10 Thread ross
PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, May 10, 2007 10:17 AM Subject: RE: adding 3 values -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 May 2007 10:08 To: mysql@lists.mysql.com Subject: adding 3 values Hi, I have 3

Re: adding 3 values

2007-05-10 Thread Peter Brawley
+double_rooms+twin_rooms AS total FROM properties WHERE total 2 AND total 10 R. - Original Message - From: Edward Kay [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, May 10, 2007 10:17 AM Subject: RE: adding 3 values -Original Message- From: [EMAIL