Re: A 3 table join question

2019-08-16 Thread Ken Tanzer
On Fri, Aug 16, 2019 at 5:54 PM stan wrote: > > On Fri, Aug 16, 2019 at 12:30:33PM -0700, Ken Tanzer wrote: > > On Fri, Aug 16, 2019 at 7:24 AM rob stone wrote: > > > > > Hello, > > > > > > On Fri, 2019-08-16 at 07:39 -0400, stan wrote: > > > > What am I doing wrong here? > > > > > > > > > > > >

Re: A 3 table join question

2019-08-16 Thread stan
On Fri, Aug 16, 2019 at 12:30:33PM -0700, Ken Tanzer wrote: > On Fri, Aug 16, 2019 at 7:24 AM rob stone wrote: > > > Hello, > > > > On Fri, 2019-08-16 at 07:39 -0400, stan wrote: > > > What am I doing wrong here? > > > > > > > > > Your view assumes that all three "streams" contain all the proj_

Re: A 3 table join question

2019-08-16 Thread Ken Tanzer
On Fri, Aug 16, 2019 at 7:24 AM rob stone wrote: > Hello, > > On Fri, 2019-08-16 at 07:39 -0400, stan wrote: > > What am I doing wrong here? > > > > > Your view assumes that all three "streams" contain all the proj_no's > whereas your test data for expense_report_cost_sum_view has no proj_no > =

Re: A 3 table join question

2019-08-16 Thread stan
On Sat, Aug 17, 2019 at 12:24:31AM +1000, rob stone wrote: > Hello, > > On Fri, 2019-08-16 at 07:39 -0400, stan wrote: > > First let me say a huge THANK YOU to all the helpful people that > > hanging out > > on this. > > > > I am changing from one type of work, going back to some database work >

Re: A 3 table join question

2019-08-16 Thread rob stone
Hello, On Fri, 2019-08-16 at 07:39 -0400, stan wrote: > First let me say a huge THANK YOU to all the helpful people that > hanging out > on this. > > I am changing from one type of work, going back to some database work > for a > project, as my old job was eliminated. I have made great progress o

Re: A 3 table join question

2019-08-16 Thread David G. Johnston
On Fri, Aug 16, 2019 at 4:39 AM stan wrote: > First let me say a huge THANK YOU to all the helpful people that hanging > out > on this. > > I am changing from one type of work, going back to some database work for a > project, as my old job was eliminated. I have made great progress on this, > th

A 3 table join question

2019-08-16 Thread stan
First let me say a huge THANK YOU to all the helpful people that hanging out on this. I am changing from one type of work, going back to some database work for a project, as my old job was eliminated. I have made great progress on this, thanks to the time and effort of lots of folks from this list