Help designing report from 3 tables
Dear all,
I had the following scenario with 3 tables:
Table A (Subscription)
ID
Name
Phone
Table B (PropertySubscribers)
ID
SubscriptionID
PropertyID
Table C (Property)
ID
PropertyID
Area
Where A is linked to B using SubscriptionID on B to ID On A
and ID in Table C to PropertyID in Table B
Table C, had the properties,
Table B, links the unique subscription ID to many properties
Tabla A, had the Subscription ID
now, I want to select all properties in Table C with a certain Area, since Table B could had duplicate records, then duplicate data could shown, how could I make report to show non duplicated data
Thanks
Subject
Written By
Posted
Help designing report from 3 tables
December 06, 2018 03:05PM
December 06, 2018 04:16PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.