How to solve circular reference with two 1 to N relationship

[amaaiia]

Hi!

I want to avoid circular reference in my data, by I don't know how to get it.

I have one main table Homes with one row per home, and each row has num_of_appliances field which is an aggregated field as integer. Then, each home (home_id), has N people living on it, so I have a reference 1:N here. Also, each home has N rooms, son here I also have a reference 1:N. As follows:

Homes:

date_1	home_id	num_of_appliances
2022-10-17	1234	3

People:

home_id	person
1234	Mike

Rooms:

home_id	room
1234	bathroom

I can't do a left join of A with B and C because that would duplicate values from all tables. The data must be separated.

How can I solve this?

Thanks!

[Lisa_P]

You are not showing us what is causing the circular reference ?

[vinieme12]

You can just load these three tables as it is without joining,

and there will be not circular reference if the data is as shown in your sample

Have you tried loading the data? can you post a snapshot of your datamodel that shows circular reference?