|Subject||Re: [firebird-support] One query either of the two WHERE clause|
|Author||Venus Software Operations|
>Token unknown - line 5, column 1
Sorry, CTEs should be separated with a comma (and you don't need to cast if using constants, only if using parameters):
WITH TMP1 (CBK, INO) AS
(SELECT 'A', 2 FROM RDB$DATABASE),
TMP2 (dValueFrom, dValueTo) ...
Thanks a lot Set. I was not aware of the requirement of the comma. I have not been introduced by you to CROSS JOIN too, thanks there have been cases where I have used 1 = 1 to get the joined data.