Hi,
Can anybody tell me what is the criteria when merging 2 query subjects into one. Will it be possible if I merge two query subjects which have no direct relationship between them. How data is fetched. Will the duplicate values be fetched
Joining two tables without a relationship is a Cartesian Join. A Cartesian join is when you join every row of one table to every row of another table. You rarely want to do this... The better solution would be to get your database remodeled so there is a relationship, if possible. I have done this before to take a fact at a yearly grain and explode it to a monthly grain. Hope this helps.