CREATE VIEW ProdajaSaPoreklom
AS SELECT datum,kg,a.ime,porijeklo
FROM prodajavoca a, voce b
WHERE a.ime=b.ime