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 strongm 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. ss1212

    need help to filter down records

    thanks you two. i really appriciate your help. i was getting a little frustrated (not with you guys) now i can think about the 4th, peace
  2. ss1212

    need help to filter down records

    i got this error with the query above The column prefix 'ager' does not match with a table name or alias name used in the query.
  3. ss1212

    need help to filter down records

    oh, lol sorry, we work together here in sf county office. we been working on this report together and he took off for the 4th of july week , so they need me to finish it
  4. ss1212

    need help to filter down records

    should it be like this ? select ISNULL(ager.cs_id, ager1.cs_id) AS cs_id, ISNULL(ager.net_ben_amt, ager1.net_ben_amt) AS net_ben_amt, max(ISNULL(ager.upd_dtm,ager1.upd_dtm)) a from cis.dbo.ag_elig_rslt ager FULL JOIN cis.dbo.ag_elig_rslt ager1 ON ager.cs_Id = ager1.cs_id (SELECT...
  5. ss1212

    need help to filter down records

    so after full join ON ager.cs_Id = ager1.cs_id ?
  6. ss1212

    need help to filter down records

    i have a simliar problem where does the ON ager.cs_Id = ager1.cs_id go?
  7. ss1212

    need help to filter down records

    isnt there a way to just tell it in the where clause to do that? not as complicated?

Part and Inventory Search

Back
Top