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

[bub]

Hi Reg,

 >> Therefore it's not a useful environment for learning SQL

That's the last thing i have to learn :-) doing SQL for almost 20 years now

But just for that reason, i am used to analyzing data through SQL 
statements, how should i approach browsing data when the app is using 
SQL on a df1 in Studio?  Through some lines of code using the table 
class?  Yep, makes sense i guess...

Thanks

Bruno

On 22/10/2020 10:18, Reg Paling wrote:
> Hi Bruno,
>
> 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.
>
> Regards,
> Reg
>
>
>
> 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 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
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
>
>