Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. miclus

    Sql Exists

    So, guys, is there a way to write my original one using "in"? This one: Select * from X where exists (select Id from Y)
  2. miclus

    Sql Exists

    Wow, now I see. Thanks dudes.
  3. miclus

    Sql Exists

    Ok. But, some confuse me like say this: Select * from X where exists (Select * from Y where X.id = Y.id) I don't see how it's actually filtering out stuff...
  4. miclus

    Sql Exists

    Thanks. The exists confuses me. Can you explain sort of the steps of how that query is working?
  5. miclus

    Sql Exists

    Can anyone explain what this statement does? Select * from X where exists (select Id from Y)

Part and Inventory Search

Back
Top