select statement

Hi,

What is the difference between
select inside select statement?
and
select inside from


thx
mcrmgAsked:
Who is Participating?
 
JimBrandleyConnect With a Mentor Commented:
Select statements inside the select statement allow you to return a value from another related table or some calculated value as a column in the rowset.

In the FROM clause, it is used typically in an IN clause to act as part of the "filter" that defines the set of rows you return.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.