Skip to content

Instantly share code, notes, and snippets.

@besquared

besquared/gist:81441

Created March 18, 2009 22:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save besquared/81441 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save besquared/81441 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
# find(
# :select => 'DISTINCT identity_providers.*',
# :joins => [:datasources],
# :conditions => 'datasources.pull'
# )
SELECT DISTINCT identity_providers.*
FROM identity_providers
INNER JOIN datasources
ON identity_providers.id = datasources.identity_provider_id
WHERE datasources.pull
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment