oak-tree/gist:9f710374d33fbb2caf03

Created September 3, 2014 14:52

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/oak-tree/9f710374d33fbb2caf03.js"></script>
Save oak-tree/9f710374d33fbb2caf03 to your computer and use it in GitHub Desktop.

Download ZIP

select all records that doesn't have relation to another table

Raw

gistfile1.sql

SELECT rp.report_id, rp.project_id, rp.project FROM `reports_projects` as rp where rp.project not in (select p.CODE from projects as p) limit 50

Author

oak-tree commented Sep 3, 2014

another options
select rp.report_id,rp.project from reports_projects as rp LEFT JOIN projects as p ON (rp.project = p.code)
where p.code is NULL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment