Archives of the TeradataForum
Message Posted: Thu, 19 Jan 2006 @ 09:50:25 GMT
Hello learned people,
I have 2 sets of questions.
1) I wanted to know what the differences between he following are and their uses
Are (a) and (c) the same? Are there any specific instances where I would want to use any of these consciously? All the while, I've been reading that these are accidental.
2) What is the difference between the two queries below? I see that Teradata makes the LOJ an equi join when I use a WHERE instead of an 'AND'
Sel a.col1, b.col2 FROM sales_order a LEFT OUTER JOIN order_line_ b ON a.order_header_id = b.header_id AND a.security_country_code = b.security_country_code; AND a.order_line_id IS NULL Sel a.col1, b.col2 FROM sales_order a LEFT OUTER JOIN order_line_ b ON a.order_header_id = b.header_id AND a.sr_code = b.sr_code; WHERE a.order_line_id IS NULL
Thanks and Regards
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|