What is it called when I nest a select statement inside a join

Posted on 2009-12-22
Last Modified: 2012-05-08
What is it called when I nest a select statement inside a join. For example:

left outer JOIN
Question by:Mr_Shaw
    LVL 75

    Accepted Solution

    derived table

    Author Comment

    so if i was documenting a query i could say....

    "I joined on a derived table"...
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    yup, you could possibly say its name

    left outer JOIN
    SELECT  a,b, from tabl2  where ..  ) as DeribedTable1

    "I joined on a derived table  'DeribedTable1'   "...
    LVL 16

    Expert Comment

    I believe it is called an in-line view. Or maybe it is just Oracle that calls it this!

    Author Closing Comment


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now