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.
PLEASE HELP!!
SELECT "ORG_ACCOUNT".ACCOUNT_NUMBER AS "Account Number",[]
WHERE ( ( "ORG_PERSON".PERSON_ID(+) = "ORG_ALT_ACCOUNT_CUST".PERSON_ID )
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 293 |
Nodes: | 16 (2 / 14) |
Uptime: | 212:43:18 |
Calls: | 6,619 |
Calls today: | 1 |
Files: | 12,168 |
Messages: | 5,317,375 |