Post reply

select ...in (select)

  • December 1, 2009 at 9:11 pm

    #137457

    Hi Mate

    Grateful if you can provide me with example where I can use the

    SELECT * FROM (table)……IN (SELECT ……)

    Thank you.

  • December 1, 2009 at 9:19 pm

    #1086246

    use AdventureWorks2008

    go

    select Name from HumanResources.Department

    where ModifiedDate in (select ModifiedDate from HumanResources.EmployeePayHistory)

    this is just an example if I understood your question correct?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply