> -Original Message-
> From: Andrew Piskorski [mailto:[EMAIL PROTECTED]
> Sent: Sunday, May 02, 2004 12:09 PM
> To: Puneet Kishor
> Cc: D. Richard Hipp; SQLite
> Subject: Re: [sqlite] CONCAT in SQLite (was Re: [sqlite]
> correct syntax
> for CASE...)
>
>
On May 2, 2004, at 6:52 PM, Kurt Welgehausen wrote:
... handicapped by not being able to use parens in a FROM clause.
It's not that you can't use parens anywhere in a FROM clause; you
just can't have the entire table-list enclosed in parens. You can
still do something like
select * from (t1
> ... handicapped by not being able to use parens in a FROM clause.
It's not that you can't use parens anywhere in a FROM clause; you
just can't have the entire table-list enclosed in parens. You can
still do something like
select * from (t1 left join t2 on ...) join t3 on ...
Regards
On May 2, 2004, at 4:07 PM, Kurt Welgehausen wrote:
FROM (contacts AS c LEFT JOIN ...
This has come up several times on this list. This behavior is
entirely consistent with the grammar for select statements
given in lang.html. The (partial) syntax is "FROM table-list";
"FROM (table-list)"
>> FROM (contacts AS c LEFT JOIN ...
This has come up several times on this list. This behavior is
entirely consistent with the grammar for select statements
given in lang.html. The (partial) syntax is "FROM table-list";
"FROM (table-list)" is not allowed. I believe this also agrees
with
>> It is '||' in Oracle, and I believe PostgreSQL as well...
"||" is the concatenation operator in std SQL, and has been at
least since 1992.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
6 matches
Mail list logo