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 TouchToneTommy 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: Ginish
  • Order by date
  1. Ginish

    simple join problem

    Hi... Check datatype of phone no in both tables. For eg, It one is char & other is varchar, it will not be identified as same because char will pad space in right side of data. Regards Ginish
  2. Ginish

    Can I do this with SQL

    Hi.... We can join all tables and then group by Account#, Project#, [Business Unit#] Bye Ginish
  3. Ginish

    Select Distinct with multiple fields

    Dear all... We can solve this by following query also... select A.* from UserMst A inner join (select Seq,Max(Rev) as Rev from UserMst group by Seq) B on A.Seq=B.Seq and A.Rev=B.Rev order by A.Seq,A.Rev Bye Ginish

Part and Inventory Search

Back
Top