Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- ga.GA_ID
- , dg2.name_ru
- FROM
- tecdoc_2016q1_europe.GENERIC_ARTICLES ga
- LEFT JOIN yii_doc.dok_ga dg1 ON ga.GA_ID = dg1.GA_ID
- LEFT JOIN yii_doc.dok_ga dg2 ON ga.GA_NR = dg2.GA_ID
- WHERE
- dg1.GA_ID IS NULL
- AND dg2.GA_ID IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement