0$10 how to do a join in Interactive SQL on DF1?

[bub]

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 postgres
>
> does the simpler syntax like the following work?
>
>
> Select * from A, B where  A.b_id = B.id
>
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
>
>> On October 21, 2020, at 9:23 PM, bub <buppeke at gmail.com> 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 http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com