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