How can I create a complex view?

[Mircea Manea]

Dear all,

I have 2 tables tbl1 and tbl2 in a relationship one-to-many.
I need to obtain a view from this 2 tables for all rows in tbl1 that has at least one corresponding row in tbl2.
And the view must look like this:
- 1 row with a predefined info1 (like a header)
- 1 row with the row that have a corresponding rows in tbl2
- 1 row with a predefined info2 (like a header)
- n rows from tbl2 related to the above row from tbl1
-... and so on...

And I need to do that on the server side.

Is there a solution to solve this or it's impossible?

Thanks a lot,
Mircea