on 11-07-2017 7:06 PM
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 -----------
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.