comparing tables

Results 1 to 3 of 3

Thread: comparing tables

  1. #1
    Join Date
    Dec 1969

    Default comparing tables

    How can I write a SQL statement that will compare fields in two tables and return the recordsets that are not alike?

  2. #2
    Steve Cimino Guest

    Default RE: comparing tables

    Research the SQL keyword JOIN. It will give you a better description on what you&#039;re trying to do... since it&#039;s impossible to determine what exactly the results you want.<BR><BR>Look at:<BR><BR>LEFT INNER JOIN<BR>LEFT OUTER JOIN<BR>RIGHT INNER JOIN<BR>RIGHT OUTER JOIN<BR><BR>etc... try the SQL Internet Resource link on the toolbar on the left.

  3. #3
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: comparing tables

    Have not worked with Joins much BUT<BR><BR>how about<BR><BR>select * from table1 where Table1.ID not in (select Id from Table2)<BR><BR>or something like this using "NOT IN" this will NOT work if there are records you wnat to retrieve from BOTH tables which are not in either of them<BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts