Get Records from Table A that are not in Table B

Hi Amie-Louise

I have used your two dataset as 'Table1(Lead Website)' and  'Table1(Database)'

Here is your DesiredTable you want

Please Note 

You have to create a Dummy Table which will hold the Intersect records of 'Table1(Lead Website)' and  'Table1(Database)'

DummyTable Screenshot

Steps:-

1. Switch to the Data View  

2. Go to the Modelling Tab and choose New Table.

3. Fire the query

DummyTable = INTERSECT('Table1(Lead Website)','Table1(Database)')

4. Again Choose New Table 

5. Fire the Query

DesiredTable = EXCEPT('Table1(Lead Website)',DummyTable)

If this is what you want then

Please give Kudos and Accept this as a solution