Advertisement
Guest User

Untitled

a guest
Apr 25th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. SELECT
  2. ga.GA_ID
  3. , dg2.name_ru
  4. FROM
  5. tecdoc_2016q1_europe.GENERIC_ARTICLES ga
  6. LEFT JOIN yii_doc.dok_ga dg1 ON ga.GA_ID = dg1.GA_ID
  7. LEFT JOIN yii_doc.dok_ga dg2 ON ga.GA_NR = dg2.GA_ID
  8. WHERE
  9. dg1.GA_ID IS NULL
  10. AND dg2.GA_ID IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement