Skip to Content
avatar image
Former Member

Inner join CRMD_ORDERADM_I with CRMD_ORDERADM_H?

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 -----------


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 07, 2017 at 07:29 PM

    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;
    Add comment
    10|10000 characters needed characters exceeded