One of the use of self joins is to relate one ticket to many others from the same form so a one-to-many kind of a relationship.
I do not have a CMDB installation I can look at to help you understand what that particular join may be used for, but you could try to dig around and see if there is a one-to-many kind of a relationship in that join that is either used for reporting or any other workflow within the application. Joe ----- Original Message ---- From: Cindy Sapochetti <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, December 18, 2006 4:46:19 PM Subject: Question re: Self-join forms - what are they? (sp. AST: Forms for Asset 7.0 app) Hi Listers - Happy Holidays! I have a basic question regarding self join forms (I'm specifically looking at AST: forms from the Asset 7.0 app). For example - AST:ComputerSystem is a join of BMC.CORE:BMC_ComputerSystem to another BMC.CORE:BMC_ComputerSystem. What's the purpose of this? If I trace this all back from a database standpoint, AST_ComputerSystem is a view, which is based on two other views, those are based on four other views, which are based on joins of 5 tables, 2 views...etc...etc...lots of nesting. I'm not sure I understand the design principle behind this, and it would be helpful if someone could point me to the documentation that might speak to this, or give me the "Remedy BackEnd Design for Dummies" synopsis. Thanks! Cindy __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
