On 01/23/2012 02:31 PM, Werner F. Bruhin wrote:
Hi Dan and Calvin,
First of all thanks for the quick response.
Based on what suggested I came up with the following which at least
got me to the point of valid SQL for base.
Using the actual table names, so tablea becomes Wine and tableb
bec
Hi Dan and Calvin,
First of all thanks for the quick response.
Based on what suggested I came up with the following which at least got
me to the point of valid SQL for base.
Using the actual table names, so tablea becomes Wine and tableb becomes
Degustation and I needed another one MarketPri
Le 23/01/12 14:26, Werner F. Bruhin a écrit :
Hi Werner,
How about using CASE WHEN()
http://hsqldb.org/doc/guide/ch09.html#expression-section
CASEWHEN(exp,v1,v2)
if exp is true, v1 is returned, else v2) - use CASE WHEN instead
Alex
--
For unsubscribe instructions e-mail to: users