-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
-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
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
+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