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 Chriss Miller 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: *

  • Users: rojo
  • Order by date
  1. rojo

    SQL subselect help needed...

    Thanks karluk, that did it. I had tried the outer join but it just wasn't in the right place. thanks again, you've been very helpful.
  2. rojo

    SQL subselect help needed...

    I'm attempting to use the following query to return a sum of hours when a flag in the db is set to a certain code('P') or if its not set at all. The first subselect returns 3 records, the second only returns 1 record and the result is that all 3 records have the value from the second subselect...
  3. rojo

    Selecting distinct rows

    I'm trying to convert a DB2 query to use in SQL server, any help on the exact syntax would be appreciated, here's the DB2 query: select distinct column_x from table_y fetch first n rows only thanks...

Part and Inventory Search

Back
Top