Associated Smart Objects

I have created associations between sevaral smart objects in a single SQL service broker, what I need to know is what next!? How do I leverage the smart object association using rules etc? Where would I see the SMOA in action? Basically I want to use the association like a SQL join but I Don;t know if this is the correct approach? Any suggestions would be gratfully received!