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
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
On Monday, June 29, 2020, David Gauthier wrote:
>
>sqf_id | sqf_sl | as_cl |
> wa_id | type
>
> +---
> --+-+---+---
>
> *
9.6.7 on linux
This query, which has 2 outer joins, gives me the records that I want...
dvdb=# select
dvdb-# sqf.sqf_runs.sqf_id,
dvdb-# sqf.sqf_runs.submitted_shelvelist as sqf_sl,
dvdb-# dvm.workarea_env.p4_changelist as as_cl,
dvdb-# dvm.workarea_env.wa_id,
dvdb-#