Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT NUME, TITLU, DOMENIU FROM ABONAMENTE
- INNER JOIN PUBLICATII ON PUBLICATII.ID = ABONAMENTE.IDP
- WHERE UPPER(DOMENIU) LIKE 'IT%'
- ORDER BY NUME
- SELECT DISTINCT TITLU, DOMENIU, PRET, PRET*1.19 AS "PRET CU TVA" FROM PUBLICATII
- LEFT OUTER JOIN ABONAMENTE ON PUBLICATII.ID = ABONAMENTE.IDP
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement