Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2006
    Posts
    3

    Unanswered: Query? Finding Fields That Do Not Match

    I have two simple tables and want to comapre the field in one table with the
    field in another. I need to identify the fileds that do not have the same data.


    Table 1 Table 2
    IP Address Port IP Address Port

    I need to query for Ports that are not the same with IP addresses that are.

    I have an inner join setup so I already have the IP addresses linked.

    Please let me know if you can help .

    Gregg Dotoli

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Query>New>Find Unmatched Query Wizard

  3. #3
    Join Date
    Nov 2006
    Posts
    3
    That wizard returns all the rows.

  4. #4
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    SELECT TABLE1.IP FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.IP=TABLE2.IP
    WHERE TABLE1.PORT<>TABLE2.PORT

    I didn't test it but it should works

  5. #5
    Join Date
    Nov 2006
    Posts
    3

    Query Worked Fine

    Worked Perfect! Thank you.

Posting Permissions

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