cancel
Showing results for 
Search instead for 
Did you mean: 

Inner join CRMD_ORDERADM_I with CRMD_ORDERADM_H?

Former Member
0 Kudos

I am trying to get the details of accounts from multiple tables:

This is the extract from the sql query.

I've tried checking each line if inner join if it returns a count of more than zero and it did however it fails at inner joining CRMD_ORDERADM_H and CRMD_ORDERADM_I .

Am I doing something wrong? Please help.

INNER JOIN CRMD_ORDERADM_H E 
ON E.GUID = D.GUID_HI


------- Everything above this returns a count of more than zero ------------

INNER JOIN CRMD_ORDERADM_I F
ON F.GUID = E.GUID;


-------- There is zero counts returned -----------


Accepted Solutions (1)

Accepted Solutions (1)

Sandra_Rossi
Active Contributor

Confusion with the GUID fields : HEADER of CRMD_ORDERADM_I is the GUID to the header table:

INNERJOIN CRMD_ORDERADM_I F
ON F.HEADER = E.GUID;

Answers (0)