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.

Trending Questions
A is 3 times as large as b and 16 degrees larger than c what is the measure of each angle? Abcd is a square and ebc is an equilateral triangle find the measure of angle aed? 4 consecutive integers whose sum is 94? How do you graph a line if given the equation in slope intercept form? List of all 4 digit combintions without repeating using only numbers 0-9? The brakes of a car are applied when it is moving at 100km per hour and provide a constant deceleration of 10 meters per second per second. how far does the car travel before coming to a stop? Y-2y plus 4? How much would 300 invested at 7 percent interest compounded continuously be worth after 4 years? Divide x2-3x-10 by x plus 2? How many 16 digit combinations can be created if numbers can be repeated? Where is 23 N 82 W? What does the word nonadjacent vertices mean? A block of wood displaced 200 mL of water from a bucket how many Cm3 is the block? What type of polynomial is formed by adding a second degree binomial to a fourth degree monomial. State the degree of this polynomial? Five sixths of a number is -60 What is the number? What is the quotient of 10.5 divided by 2.5? How do you calculate the dimensions of a rectangle if you know the perimeter and the length? A ladder 15ft long leans against a wall the top of the ladder reaches a height that is 3 ft more than twice the distance from the base of the ladder to the wallhow high up the does this ladder reach? What is an expression which combines variables numbers and at least one operation? How many miles per hour is mach 2.2?