sql create view in one to many relation

Posted by new to sql on Stack Overflow See other posts from Stack Overflow or by new to sql
Published on 2010-04-05T05:43:50Z Indexed on 2010/04/05 5:53 UTC
Read the original article Hit count: 186

Filed under:

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 ?

© Stack Overflow or respective owner

Related posts about sql