I have one company.table with company name, lowest retailer number and highest retailer number
I have one retailer.table with retailer name, retailer number
To find out for which company a retailer works, his retailer number has to be between the lowest and highest number in the company table.
In framework manager i made a cross join.
.... where ((company.lowest retailer number <= retailer.retailer number) and (company.highest retailer number >= retailer.retailer number) )
In framework manager I receive the correct information. The retailer is related to the right in company.
When creating a report however, the retailer is related to every company in the company table.
In the properties I set cross joins to allowed.
What am I doing wrong ?
This actually is no cross-join. It is officially called a 'non-equi' or 'theta' join. A cross join yields n*m results for tables with n resp. m rows, cause no relationship is defined btween the tables. So, you should not need to allow cross-joins.
If lowest retailer number and highest retailer number
have no overlap between rows in the company table,then you should have no multiplying of rows in the resultset..
Hello blom0344.
Thank you for your answer.
I found the cause of the wrong results. There was another table that caused the problem.