syntax for a search on 2 tables

paulhorne · April 23, 2018 9:13AM

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

RichardL · April 23, 2018 12:00PM

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 · April 23, 2018 12:15PM

v11

RichardL · April 23, 2018 1:44PM

Hi @paulhorne

Thanks again for your reply.

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

Best

Richard.

paulhorne · April 23, 2018 1:58PM

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

syntax for a search on 2 tables

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk