Skip to content

Instantly share code, notes, and snippets.

@Vannevelj
Created July 14, 2014 10:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Vannevelj/557802abd905a8b13d22 to your computer and use it in GitHub Desktop.
Save Vannevelj/557802abd905a8b13d22 to your computer and use it in GitHub Desktop.
squrrel
select Tags.tag_id, Tags.tag_name
from AssetTags
left join Tags
on AssetTags.tag_id = Tags.tag_id
where AssetTags.asset_id = '" + assetId + "';
select Tags.tag_id, Tags.tag_name
from Tags
where Tags.tag_id in (
select AssetTags.tag_id
from AssetTags
where AssetTags.asset_id = '" + assetId + "');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment