How can we help you today? How can we help you today?

syntax for a search on 2 tables

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

Comments

4 comments

  • 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.
    RichardL
    0
  • paulhorne
    v11
    paulhorne
    0
  • RichardL
    Hi @paulhorne

    Thanks again for your reply. 

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

    Best

    Richard.
    RichardL
    0
  • 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
    paulhorne
    0

Add comment

Please sign in to leave a comment.