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

[Reg Paling]

Hi Bruno,

You can use Omnis Native DML and OmnisSQL both at once from the same 
instance of Omnis.

The OmnisSQL DAM is much like any other DAM so if the table class is 
already set up, then use it...  And from memory "=*" works for a left 
outer join, within unspecified limitations.

Regards,
Reg


On 22/10/20 4:09 pm, bub wrote:
> 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 
>>
>>