Advance Search, compare and display records

[joelo]

Please help me out.....I want to search for records in Table1 and use the search results to compare records in Table2 .... and display non-matching records

Please any with any IDEAS

Thanks in Advance

[Ribeyed]

hi,
you need to create and sql statement which joins the two tables then use "NOT IN" within your statement.