If you are unable to create a new account, please email support@bspsoftware.com

Author Topic: Join three table via an Expression Filter  (Read 5129 times)

jcuiskelly

  • Guest
Join three table via an Expression Filter
« on: 25 Jan 2007 03:37:15 pm »
Does any know how to join three tables with out using an SQL statement?  This is what I am trying to do.  I need 'Y' from table 'CC' and Table 'AA' has nothing in common with Table 'CC'.  So, I am trying to use Table 'BB', which has common fields between Table 'AA" and Table 'CC'.  'X' from Table 'AA' equals 'X' from Table 'BB', 'Y' from Table 'BB' equals 'Y' from Table 'CC'.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,705
  • Forum Citizenship: +677/-10
  • Cognos Software Muppet
Re: Join three table via an Expression Filter
« Reply #1 on: 02 Feb 2007 04:11:44 am »
Hi,

I don't think this is possible from within Cognos Query.  The joins would need to be set up in Architect then the package republished.

Regards,

MF.
Meep!

jcuiskelly

  • Guest
Re: Join three table via an Expression Filter
« Reply #2 on: 22 Feb 2007 04:31:17 pm »
Thank you for the information.  :)