topic Re: sub query in Application Development and Automation Discussions

sub query

Former Member — Mon, 30 Jul 2007 06:23:10 GMT

what is sub query?

Re: sub query

Former Member — Mon, 30 Jul 2007 06:27:27 GMT

Sub query is query inside a query

select country from dbtab1

where country not in (select country from dbtab2).

Reward if useful

Re: sub query

Former Member — Mon, 30 Jul 2007 06:28:57 GMT

Hi,

A subquery is a special SELECT statement containing a subquery within particular conditions of the WHERE or HAVING clauses. You cannot use them in the ONcondition of the FROM clause. Their syntax is:

( SELECT result

FROM source

[WHERE condition]

[GROUP BY fields]

[HAVING cond] )

In simple language,

Query inside Query.

Output of inner query will be given to the outer query.

Reward if useful!

Re: sub query

Former Member — Mon, 30 Jul 2007 06:37:26 GMT

THANK U.