Adsense
Popular Posts
- Code update from PHP 7.4 to PHP 8.1 - PhpSpreadsheet
- MySQL workbench -"Could not decrypt password cache"
- Code update from PHP 7.4 to PHP 8.1 - Worksheet/Iterator.php
- Rendering HTML tags inside textarea
- axios handle blob type data
- Unix Utils and wget in Windows
- increase mysql query speed
- Setup vi syntax for PHP
- Get WAMP running on EC2
- add comment to table columns in phpMyAdmin
Thursday, October 16, 2014
MySQL, find those values not in another table
In MySQl, Find those emplid in courses_offered_has_stakeholders table, but not in stakeholders table
SELECT DISTINCT table1.emplid
FROM courses_offered_has_stakeholders as table1 LEFT JOIN stakeholders as table2 ON
table2.emplid=table1.emplid
WHERE table2.emplid IS NULL;"
Labels:
MySQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment