syntax for a search on 2 tables

paulhorne

how do I search a list of applications from one table where no account record exists on another table

RichardL

Hi @paulhorne

Thanks for your post. 

Since the thread is in previous compare versions I'm wondering what version you are using? 

I look forward to your reply. 

Kind regards

Richard Lynch. 

paulhorne

v11

RichardL

Hi @paulhorne

Thanks again for your reply. 

Could you provide an example of what you're looking to do please? 

Best

Richard. 

paulhorne

I have a query where a user need to find out how many applications there are without accounts so I need to find all records from  table1 that do not have matching accounts from another  table2 hard to explain. thank you for helping