Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Correlated subqueries and ANSI
Thanks JarlH and I agree with you but unfortunately I have to deal with the Standard. I found what you stated, too. But I thought that there has to be explained in more detail, what it's meant about "correlated subqueries". For my understanding what you mentioned means that a correlated... -
Correlated subqueries and ANSI
Ok, I found following text passages, but I'm not sure if I interpreted them right.. - "If a <column reference> CR is contained in a <table expression> TE and the qualifying scope of CR contains TE, then CR is an outer reference to the qualifying table of CR." - "Let TRL be the ordering of... -
Correlated subqueries and ANSI
Hello, can anyone tell me where it's mentioned in the standard document (part 2) that correlated subqueries are supported and where I am able to use them? I found out that ANSI mentions Feature E061-13 "Correlated subqueries" but I didn't found where it's specified, neither in the rules for...
