| Subject | RE: [firebird-support] One query either of the two WHERE clause |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2013-11-26T07:38:20Z |
>Token unknown - line 5, column 1Sorry, CTEs should be separated with a comma (and you don't need to cast if using constants, only if using parameters):
>TMP2
WITH TMP1 (CBK, INO) AS
(SELECT 'A', 2 FROM RDB$DATABASE),
TMP2 (dValueFrom, dValueTo) ...
HTH,
Set