77986/select-all-records-from-one-table-that-not-exist-another-table
Here is my two table as:
table1 (id, name) table2 (id, name)
Query:
SELECT name FROM table2
Hello @kartik,
You can either do like this:
SELECT name FROM table2 WHERE name NOT IN (SELECT name FROM table1)
or
SELECT name FROM table2 WHERE NOT EXISTS (SELECT * FROM table1 WHERE table1.name = table2.name)
Hope it helps!!
Thank you!
Hello @kartik, In SQL Server, use MERGE MERGE INTO YourTable ...READ MORE
Hello @kartik, Include the first file into the ...READ MORE
Hello @kartik, You could use the copy() function : // Will ...READ MORE
Simply, $source = 'Source_file_location' ...READ MORE
Hello guys, Can Someone helps me to find ...READ MORE
Hello, In the error callback or $.ajax you have three ...READ MORE
Hello @kartik, If your script is called myScript.js ...READ MORE
Hello @kartik, Try this code : // Create an ...READ MORE
Hello @kartik, This is not possible in PHP. All ...READ MORE
Hello @kartik, Set posts_per_page parameter in args to ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.