Query to Compare values of two Tables and Return No Matching values from Second Table

[JithuAccess]

Hello Guys,

I have a Table to store a new application. I have another table to store review hours. I want to find the details of the applications which are not yet gone for review. For Example, if there are 10 Applications and out of them only 4 has gone for review, I want to find the details of those 6 application which are not gone for review. These are the values in my Tables:

I am attaching the database

Thank You

 

[plog]

LEFT JOIN:

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

SHow all from Application table, then LEFT JOIN Review Table and set the criteria for the name field of the Review Table to NULL

 

[mike60smart]

Hello Guys,

I have a Table to store a new application. I have another table to store review hours. I want to find the details of the applications which are not yet gone for review. For Example, if there are 10 Applications and out of them only 4 has gone for review, I want to find the details of those 6 application which are not gone for review. These are the values in my Tables:

View attachment 93674


View attachment 93675



View attachment 93676

I am attaching the database

Thank You

Hi

Your 2 tables have no Autonumbers to identify each Record, and they are not related in any way.

Is this your actual current database?

 

[JithuAccess]

LEFT JOIN:

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

SHow all from Application table, then LEFT JOIN Review Table and set the criteria for the name field of the Review Table to NULL

Thanks a lot. It worked perfect