WHERE clause JOINS?
maxh at carrubba.com
Fri Jun 17 19:45:34 UTC 2022
I'm assuming what they mean by that is doing joins like this
select * from table_a a, table_b b, table_c c
It's an odd / older style of doing joins that I never use but I've seen it in some older code in the postgres apps i've worked on.
From: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> on behalf of Das Goravani <goravanis at gmail.com>
Sent: Friday, June 17, 2022 2:21 PM
To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Subject: WHERE clause JOINS?
In the Omnis Docs, in section covering the Query Builder, a sub section exists that describes how to create a Query Class from your Query Builder Query.
It says this sentence last:
Note that this feature is restricted by the same limitations as a query class and therefore only supports ‘Where Clause’ joins.
I don’t understand this sentence.
First of all what is a WHERE CLAUSE JOIN? I am familiar only with joins being in the FROM clause part of the SELECT statement.
And how are Query Classes limited to the WHERE clause?
I thought that a query class was a FROM JOIN potentially or "by default".
Manage your list subscriptions at https://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en