Database question

[peterg12345]

I am having to come up with a query that will extract for a given block:
1). block name
2). operations
3). requirements
4). use case name
5. sequence diagram name
6). sender
7. receiver

I have the first 5 working right (joining t_object. t_operation, t_diagramobjects, t_diagram, and t_object again).

I also have the last two elements (joining t_object, t_connector, and t_object again).

But, I can't seem to be able to join the the two subqueries correctly, because I get duplicate rows.

Any suggestions? (I can post the queries if needed)

TIA

Pete

[bioform]

options about unique rows I believe... (DISTINCTROW)

Hope that helps...