Skip to content

Instantly share code, notes, and snippets.

@YMA-MDL

YMA-MDL/retrieve items without a specific relationship.sql

Created July 12, 2019 15:06
Show Gist options
  • Save YMA-MDL/325b791a4791cd8adeed109e81beccc7 to your computer and use it in GitHub Desktop.
Save YMA-MDL/325b791a4791cd8adeed109e81beccc7 to your computer and use it in GitHub Desktop.
Download ZIP
#aras #sql
Raw
retrieve items without a specific relationship.sql
SELECT *
FROM ALS_Activity act
LEFT JOIN ALS_ActivityPredecessors pre
ON act.id = pre.source_id
WHERE pre.source_id IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment