> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of Helen Borrie
> Sent: 05 June 2006 16:03
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Updating left outer join
>
> At 12:13 AM 6/06/2006, you wrote:
> >
> >
> > > -----Original Message-----
> > > From: IBObjects@yahoogroups.com
> > > [mailto:IBObjects@yahoogroups.com] On Behalf Of Helen Borrie
> > > Sent: 05 June 2006 14:47
> > > To: IBObjects@yahoogroups.com
> > > Subject: RE: [IBO] Updating left outer join
> > >
> > > At 10:08 PM 5/06/2006, you wrote:
> > >
> > > > >
> > > > > Try improving the syntax for the main query:
> > > > >
> > > > > select
> s.rec,s.shipment,s.whs,s.pid,s.qty,s.alloc,w.description
> > > > > from warehouses w
> > > > > left outer join shipment_allocations s
> > > > > on s.whs=w.ref
> > > > > WHERE s.shipment=:shipment and s.pid=:pid
> > > > >
> > > > > Helen
> > > > >
> > > >That breaks it, I always want the grid populated with
> fields from
> > > >warehouses even when there is no data in shipment_allocations.
> > > >Changing it as you suggest returns no rows ;-(
> > >
> > > That sounds suspect. Where did you test it?
> > >
> > > What's the PK of warehouses?
> > >
> > > Helen
> > >
> >Sounds logical to me ;-) if you put the conditions in the
> where clause
> >you are filtering the joined rows - result=none. However if you put
> >them in the join conditions you filter the right hand table only,
> >therefore returning the left table rows.
>
> It doesn't sound logical to me. Current Fb versions have a
> distribution problem with RIGHT joins which can be worked
> around by meshing the join and selection conditions.
>
> The selection conditions here are on the left table, not the
> right. That means the left stream will be made first, before
> testing the right stream.
>

Conditions are on the right table.

> So I'm still suspicious about how you're testing this.
>
> >Tested in IBExpert.
>
> It still doesn't say how you're testing it, e.g. how (or if)
> you are applying the values to the parameters.
>

Either substituting numbers for the params or letting IBExpert do it - same
result.

> >Tables have PK of rec.
>
> OK.
>
> Helen
>
> P.S. I'm going off the radar for a few days to go to the
> Wintry South for Delphi conferences. Might get a chance to
> look over list and IBO customer mail briefly but I'm not
> counting on it.
>

I should just enjoy yourself ;o)

Regards
Paul