Re: Can't seem to mix an inner and outer join in a query and get it to work right.

2020-07-01 Thread David G. Johnston
The convention here is to bottom post or inline responses. On Wed, Jul 1, 2020 at 9:51 AM David Gauthier wrote: > Actually, I want the outer join first. If it finds something, then move > on to the inner join and filter out all those that don't join to a rec with > 'autosmoke'. But if the oute

Re: Can't seem to mix an inner and outer join in a query and get it to work right.

2020-07-01 Thread David Gauthier
Thanks! Actually, I want the outer join first. If it finds something, then move on to the inner join and filter out all those that don't join to a rec with 'autosmoke'. But if the outer join does not connect to the workarea_env table, then just return what you have (the purpose of the outer join

Re: Can't seem to mix an inner and outer join in a query and get it to work right.

2020-06-29 Thread David G. Johnston
On Monday, June 29, 2020, David Gauthier wrote: > >sqf_id | sqf_sl | as_cl | > wa_id | type > > +--- > --+-+---+--- > > * arazhang_20.06.28-20:59:06_soc_navi24_main@44047