Re: Many To Many Relationships

From: Tonkuma <tonkuma_at_jp.ibm.com>
Date: 16 Apr 2007 05:40:11 -0700
Message-ID: <1176727211.202388.214760_at_p77g2000hsh.googlegroups.com>

One way is to add sequence number for ITEM_CATEGORY_MAP by using ROWNUMBER() OVER(PARTITION BY ITEMID ORDER BY CATEGORYID), then use recursive query. Received on Mon Apr 16 2007 - 14:40:11 CEST

This message: [ Message body ]
Next message: Bob Badour: "Re: delete cascade"
Previous message: Cimode: "Re: Many To Many Relationships"
In reply to: Loon: "Many To Many Relationships"
Next in thread: David Cressey: "Re: Many To Many Relationships"
Reply: Tonkuma: "Re: Many To Many Relationships"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message