sql create view in one to many relation
- by new to sql
i want to create a view in a one-to-many relatiom.
here is my relations:
(a -* b) and
(a -* c).
i want to create a view to have this data :
a1 - (all b's related to a1 + all c's relted to a1)
i don't wnat sth like (a1 ,b1,c1 - a1,b1,c2 ,...)
how can i create this view ?