Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1)
- INSERT INTO Osoby
- (1, N'Paul', N'Erodos', M,)
- INsert INTO Obywatelstwo
- (1, N'Wegry')
- 2)
- SELECT DISTINCT o.Id_Osoby, o.Imie, o.Nazwisko o.Plec, FROM
- Osoby o JOIN Obywatelstwo n
- ON o.Id_Osoby=n.Id_Osoby
- WHERE
- ((n.Kraj = 'Gruzja' AND o.Nazwisko NOT LIKE '%dze' AND o.Nazwisko NOT LIKE '%szwili') OR
- (n.Kraj = 'Izrael' AND o.Nazwisko = 'Cohen' AND o.Nazwisko = 'Gadol'))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement