Java Glossary : correlated subquery

Java definitions: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

You are here : home : Java Glossary : C words : correlated subquery.

correlated subquery: In SQL, a query that cannot be evaluated independently, but that depends on the outer query for its results. The inner query has to be repeated once for each row that the outer query returns. These drive some simple-minded SQL engines insane.

home	Canadian Mind Products
	mindprod.com IP:[24.87.56.253]
	Your IP:[80.134.30.163]
	You are visitor number 1033.
	Please send errors, omissions and suggestions
	to improve this page to Roedy Green.
	You can get a fresh copy of this page from:	or possibly from your local J: drive mirror:
	http://mindprod.com/jgloss/correlatedsubquery.html	J:\mindprod\jgloss\correlatedsubquery.html