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

[Doug Easterbrook]

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