var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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 .
Query>New>Find Unmatched Query Wizard
That wizard returns all the rows.
SELECT TABLE1.IP FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.IP=TABLE2.IP
I didn't test it but it should works
Query Worked Fine
Worked Perfect! Thank you.