create view memomealview
as
 select sndlmeal.mealdlid,sndlmeal.mealname,snxlmeal.mealxlid,snxlmeal.xlname 
  from sndlmeal  inner join snxlmeal 
   on  sndlmeal.mealdlid=snxlmeal.mealdlid
go
 
create view mealkeyxlview
as
 select snmeal.mealid,snmeal.mealxlid,snxlmeal.xlname,snkeymeal.keynameid1,snkeymeal.keynameid2,snkeymeal.keynameid3
   from snmeal inner join snkeymeal
   on  snmeal.mealid=snkeymeal.mealid inner join snxlmeal
   on snmeal.mealxlid=snxlmeal.mealxlid 
go