Adsense
Popular Posts
- Install APXS in Redhat Linux
- MySQL workbench -"Could not decrypt password cache"
- Transfer modules between sites
- JavaScript, remove trailing insignificant zeros after toFixed function
- Set Windows path command line
- datatable order by nunmeric
- MySQL date created and date modified
- super(props) in React
- PHP, dump varailbes in a format way
- React: connect(mapStateToProps, mapDispatchToProps)
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