0$10 how to do a join in Interactive SQL on DF1?
I would not invest too much time or effort into OmnisSQL. Some joins
work, as long as they are very simple. More complex queries often just
don’t work. Therefore it’s not a useful environment for learning SQL.
On 22/10/20 3:41 pm, bub wrote:
> Hooray, it does!!! Think Omnis, think simple 🙂 Thanks Doug!
> On 22/10/2020 09:59, Doug Easterbrook wrote:
>> I don’t think omnissql for DF1 allows that syntax that you can use in
>> does the simpler syntax like the following work?
>> Select * from A, B where A.b_id = B.id
>> Doug Easterbrook
>> Arts Management Systems Ltd.
>> Phone (403) 650-1978
>>> On October 21, 2020, at 9:23 PM, bub <firstname.lastname@example.org> wrote:
>>> Help, help, why i can’t do something like this in Interactive SQL on
>>> a DF1 session?
>>> Select * from A
>>> left join B ON A.b_id = B.id
>>> i tried ‘join’ ‘inner join’ etc, i keep on getting ‘Badly formed SQL
>>> statement’, i get that message way too much in all kinds of standard
>>> SQL statements… @##$@
>>> I am working my way to understanding Studio by stepping through
>>> existing app code and now that i am on this subject, maybe i don’t
>>> have to go so much into interactive SQL if i understood a bit more
>>> about this whole file, table, schema stuff. I start to get the
>>> basics but where am i looking to find the table-relations, are these
>>> normally defined in the table classes?
>>> Thanks as always
>>> Bruno Huyssen
>>> Manage your list subscriptions at lists.omnis-dev.com
>>> Start a new message -> mailto:email@example.com
>> Manage your list subscriptions at lists.omnis-dev.com
>> Start a new message -> mailto:firstname.lastname@example.org
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:email@example.com