answersLogoWhite

0

A join will join two or more tables together by a field related to both tables (ie, relationship of primary and foreign keys). It is typically easy to understand.

A subquery statement involves a SELECT statement that selects particular values from a table. The values that the select query selects is dependant upon the subquery. The subquery itself is another SELECT statement.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What are co related sub queries?

The main differencre between subquery and co-related subquery is that in subquery child query is executed first n then parent,but in co-related subquery main query is executed first(even though parenthesis are present) and then child query. Example of co-related subquery select dname from dept where exists (select deptno from emp where dept.deptno=emp.deptno); select dname from dept where not exists (select deptno from emp where dept.deptno=emp.deptno);


What is a correlated query?

Correlated query has a subquery in it which accesses the column name of a table alias which is outside the subquery.


What is the difference between join and inner join?

One is inner the other is not... Plum


What are subqueries used for in a database?

A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.


State the basic difference between Inner join and Left Outer Join?

Inner join is from the inside while left out join is from the outside


An SQL subquery can appear inside of another SQL subquery?

Yes, but more the levels of sub queries, the more would be the time taken to execute the query.


What the difference between IIT-JEE and AIEEE?

The Difference lies in the portions and the list of collages that you are eligible to join if you pass in the exam.


What is the difference between institute and academy?

Institute is a place where you are taught. After being in institute, you join an academy.


What is difference between join and joint?

Join-become part of a group, joint- where 2 items come together, also slang for marijuana cigarette


What is the difference between estuary and the ocean?

It is where streams join to form a river


Which construct in SQL is used to test whether a subquery has any tuples in its result?

Exists


What is the difference between a best fit graph and a line graph?

a line graph will join all of the points yet a best fit graph will only join the dots which follow the pattern.