Post Author: Jethro
CA Forum: WebIntelligence Reporting
Hi All,Hopefuly this is a simple one for somebody... Although new to BO XI, I have several years experience on Databases so jumped straight into WEBI
I have two tables connected via a value called 'resource item' in the primary table to a 'resource item' in the secondary table, this works when items exist in both tables.
Primary table Job information including a resource short code fieldSecondary table Resource short code and description, cost for resource . . .The problem I have is when no resource exists in the primary table the record is not included in the result. A SQL left hand join would perform this action in other DBases I have used and the manual doesn't go into much detail on joins.
Can anybody tell me what I have to do to show the primary result with no resource item or resource item description etc. from the secondary table...Thanks in advance