I am attempting to create a report that shows both Primary and there Alternates however both tables I have use the same PERSON_ID identifier.
Can someone assist me or give me something to try. The query below
gives me output, but it only gives me Primary First Name/Last Name ect,
email address ect ect and then it only shows the Alternates ID number
opposed to giving me there First NAME/Last name ect ect. I know I need
to use a join statement, but I have no experience with JOINS.
SELECT "ORG_ACCOUNT".ACCOUNT_NUMBER AS "Account Number",
WHERE ( ( "ORG_PERSON".PERSON_ID(+) = "ORG_ALT_ACCOUNT_CUST".PERSON_ID )
|Location:||Huddersfield, West Yorkshire, UK|
|Nodes:||8 (1 / 7)|