|
|
Archives of the TeradataForum
Message Posted: Thu, 13 Dec 2007 @ 11:27:41 GMT
Subj: | | Re: A question on Left Join |
|
From: | | Victor Sokovin |
| I get back zero rows. Am I missing something? Irrespective of how the plan is formed, should it not return 45 rows atleast? Request you to
please opine. | |
Your expectation is correct so if you submit the query exactly as you presented it here for us (with real table names) you should at least get
45 rows.
My opinion? Stop using the database giving you incorrect answers. Databases are only worth using if they provide correct answers.
Regards,
Victor
| |