On Mon, Dec 30, 2019 at 02:47:53PM -0700, Michael Lewis wrote:
> >
> > LEFT join mfg_vendor_relationship on
> > mfg_vendor_relationship.mfg_key = mfg_part.mfg_key
> > AND
> > mfg_vendor_relationship.project_key = bom_item.project_key
> > LEFT join vendor on
> >
>
> LEFT join mfg_vendor_relationship on
> mfg_vendor_relationship.mfg_key = mfg_part.mfg_key
> AND
> mfg_vendor_relationship.project_key = bom_item.project_key
> LEFT join vendor on
> mfg_vendor_relationship.vendor_key = vendor.vendor_key
>
Perhaps I am missing
I am working on a system whee one group of folks inputs portions of data
into a table, and a 2nd completes the data for each row.
The engineers enter in the items they need into a BOM table, and purchasing
agents get quotes and create PO's. There is not a fixed relationship between
the parts
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?
> > > >
> > >
> > >
>
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
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
> =
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
>
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
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,
>
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
10 matches
Mail list logo