Time has come to provide non-normalized views for end user consumption. Woe is me! I don't know how to provide a non normalized view for a one to many relationship. The many side has a fixed (3)number of rows.

Please fill in the blanks:

CREATE SQL VIEW WOEISME AS ;
SELECT TABLE1.*,

I would appreciate any help

Thanks

Glenn