Help designing report from 3 tables
Posted by: Houssam Ballout
Date: December 06, 2018 03:05PM

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

Options: ReplyQuote


Subject
Written By
Posted
Help designing report from 3 tables
December 06, 2018 03:05PM


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.