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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

multiple joins between two tables

Started by karthik12345, 13 Apr 2016 06:40:00 AM

Previous topic - Next topic

karthik12345

Hi all,
   
    I gave the multiple joins between two tables.
  Entries and messages tables
     Entry-id <-> message id-1
     Entry-id <-> message id-2
    Entry-id <-> message id-3
    Entry-id <-> message id-4
     I created 3 shortcuts of messages table and taken message id-1 from messages table, message id-2 from shortcut -1, message id-3      from shortcut-2 and message id-4 from shortcut-3
    Which I followed is correct way or is there any other way to do this.

Thanks,
Karthee

HalfBloodPrince

I guess you have to create alias shortcut.