On 8/30/06, Frank Schönheit - Sun Microsystems Germany < [EMAIL PROTECTED]> wrote:
Hi Don, >>O.k., I think I know the source of the problem now. My db consists of 2 >>tables. When I remove the 'survey2006' table, I get proper counts from >>tbl_BizContact. When I add tbl_survey2006, that's where things go goofy. > > Well, I just tried running the query on each table independently with great > success, just using the standard query design mode. I don't exactly know > why I couldn't pull a field from each table, but would that have anything to > do with the relationship between the tables? A "SELECT <something> FROM <table1>, <table2>" creates a cartesian product between those two tables. That is, it will have n*m rows, when n and m are the number of rows of in the single tables. That's why this high numbers in your results.
Thanks for your explanation. I didn't realize that. I sure wouldn't have known it was called a 'cartesian product'.
