Create a new table with difference between the Fields

[Kohli]

I have 2 tables .

Table1:

Ticket number

Flight No

From,

To

Table2:

Ticket number

Flight No

From,

To,

fare

In Table1 Ticket number field has Table2 Ticket number field data as well extra records.

I want create a new table with Extra records in the Table1.

[andrey_krylov]

Hi, see this post

Re: How to compare 2 tables and put non-matching results?

I hope it will be helpfull.