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

  • Users: pip0
  • Order by date
  1. pip0

    Compare two table, based on two fields.

    I have two identicle tables, that have two index fields, Type and Code. Both of these fields can have the same value in the respected field but not a unique match where two records in the same table have the same values for both Type and Code. TableA Type=A Code=101 Type=A Code=102 Type=A...
  2. pip0

    Comparing 2 tables for differences.

    Thanks, to those of you who have repsonded, I was to complete this by using the IsNull function. Does any one know some where we can search to see what all functions are available and what they do? Thanks
  3. pip0

    Comparing 2 tables for differences.

    SELECT ... FROM Table_A WHERE {Common_Field} NOT IN (SELECT {Common_Field} From Table_B) The tables that I'm accessing are Foxpro Dbases, I can not access via ODBC. The above command lines that you gave do not appear to work. I entered the following: Select r_cssmst.'comp_id' FROM...
  4. pip0

    Comparing 2 tables for differences.

    I'm wanting to compare two tables and pull out the non matching records from table A that does not exist in table B. The two tables have a common Field in each of them. Thanks Michael

Part and Inventory Search

Back
Top