Re: Need some SQL DB Help

[Mike Wills <koldark@xxxxxxxxx>]

To me it appears to return the correct result set. I have no way to verify 
since the main key in file two doesn't exist in file 1. Here is what I am 
talking about:

File 2 (DBPOSCM) Comment Codes
Key is 
PROCURE_GROUP
COMMENT_CODE

File 1 has PROCURE_GROUP, but doesn't COMMENT_CODE anywhere for a colum 
name. So it must be held some where else, and that is what I am trying to 
figure out.

On 5/4/05, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> 
> What result set does it return?
> 
> A:
> ....+....1....+....2....+....3....+...
> USERID Initial Default
> Company Library
> RALPH 01 -
> POTSIE 01 -
> JONI 02 ROB
> 
> B:
> ....+....1....+....2....+....3....+...
> USERID Initial Default
> Company Library
> RALPH 01 -
> RALPH 01 ROB
> JONI 02 -
> JONI 02 ROB
> POTSIE 01 -
> POTSIE 01 ROB
> 
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> Mike Wills <koldark@xxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 05/04/2005 11:46 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> To
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> cc
> 
> Subject
> Re: Need some SQL DB Help
> 
> 
> I am trying to reverse engineer this very wacky database design. If you
> have
> seen Lawson Software version 8 you know what I mean. These two files can
> be
> joined somehow. I don't see any possible link. I know they can because in
> the application they are joined.
> 
> On 5/4/05, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> >
> > Define "works".
> >
> >
> 
> --
> Mike Wills
> Midrange Programmer/Lawson Software Administrator
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 


-- 
Mike Wills
Midrange Programmer/Lawson Software Administrator
koldark@xxxxxxxxx
http://mikewills.name
Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.