use food

create view food.orchard
  as select * from trees.orangeTrees

select A.apples, B.oranges
from fruitSalad A
join orchard B on A.compareKey = B.compareKey