0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people looking to bypass life's everyday problems with simple tricks

WITH css_tags AS
(
  SELECT 
  t.TagName, 
  t.Id, 
  ts.SourceTagName as source_tag_name_as_join_criteria, 
  ts.TargetTagName
  FROM Tags t
  LEFT JOIN TagSynonyms ts
  ON t.TagName = ts.SourceTagName
  WHERE lower(TagName) LIKE '%css%'
)
SELECT * FROM css_tags

view current version

edited dec 6

created dec 6 user28646684