Who's On?

	Membership:
	Latest: HireIQ
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5264

	People Online:
	Visitors: 460
	Members: 0
	Total: 460

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

joining these 2 tables

3 Replies

1 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

wally

Basic Member Send Private Message

Posts: 11

1/13/2016 12:25 AM

I am trying to join two tables, APINVOICE and APDISTRIB. Can you please help me understand the following below which is posted on https://www.lawsonguru.co...ables/APINVOICE.html

Scroll down to the "one to many relationships" then to the APDISTRIB part.

Is that saying I need to join API-OBJ-ID to both APD-API-OBJ-ID and APD-DIST-SEQ-NBR or is it saying I have a choice between the two?

Kwane McNeal

Veteran Member Send Private Message

Posts: 479

1/13/2016 12:49 AM

The link is with OBJ-ID. The reason SEQ-NBR is also needed is that it's possible that there are multiple distributions for a single invoice, usually when you have partial pays, or recurring invoices and the like.

wally

Basic Member Send Private Message

Posts: 11

1/13/2016 12:54 AM

so then I link API-OBJ-ID to "both" APD-API-OBJ-ID AND APD-DIST-SEQ-NBR?

John Henley

Posts: 3351

1/13/2016 12:26 PM

No, you left outer join from APINVOICE (API) to APDISTRIB (APD) by joining API.OBJ_ID to APD.API_OBJ_ID.
You do not include APD-DIST-SEQ-NBR in the join.