>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.*, fields_from_table2 ;
from table1 ;
[left] join table2 on table1.keyid = table2.table1_id ;
[where some_filter_criteria] ;
order by some_fields
The optional [left] join also retrieves any Table1 records where there are no Table2 records.
Mark McCasland
Midlothian, TX USA