Hi Guys,
i changed relationships:
Now it seems that should be good.
One problem still. When i am creating query with all data like:
Code:
SELECT DISTINCT t_Versions.Version_name, t_Topologies.Topology_name, t_Clients.Client_info, t_Clients.Client_name, t_ServerSizeInfo.Memory_sizeLabels, t_SupportedSystems.Systems_name
FROM t_Versions INNER JOIN (t_Topologies INNER JOIN (t_SupportedSystems INNER JOIN (t_ServerSizeInfo INNER JOIN t_Clients ON t_ServerSizeInfo.ServerSizeInfo_Id = t_Clients.ServerDetailedInfo_ID_FK) ON t_SupportedSystems.SupportedSystems_ID = t_Clients.SupportedSystems_ID_FK) ON t_Topologies.Topologies_ID = t_Clients.Topologies_ID_FK) ON t_Versions.Versions_ID = t_Clients.Version_ID_DK;
Even there is distinct clause still i have duplicates in my output.
When i am deleting Primary key (this is a cause of duplicating) duplicates are dissaperead.
How can i avoid this?
Best,
Jacek