9. Select Accounts without Contacts

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to get the name of all accounts that don't have any contacts linked to them https //www youtube com/watch?v=wdo4b aqufa\&list=plfs7 dts7jwyhwe scy5z4qvgbh2ilspj\&index=9 or follow the steps below 1\ input on the selections overview screen, click on new to create a new selection drag deselect demo accounts to the selected data extensions section drag deselect demo contacts on top of deselect demo accounts in the selected data extensions section create the relationship deselect demo accounts field id deselect demo accounts without matching deselect demo contacts deselect demo contacts field accountid 2\ output hit the create data extension button, enter a name, eg accounts without contacts, and press save select the following fields by either double clicking on them or dragging them to the section on the right company name from accounts click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with field company name the results table shows only accounts that don't have contacts linked to them