take a look at this http://www.devx.com/dbzone/Article/17403/1954
On Sat, Nov 15, 2008 at 10:56 PM, ray <[EMAIL PROTECTED]> wrote: > > Hi, All > > I have two tables named product and category: > Product table: > prod_id prod_name ... > Category table: > cat_id cat_name ... > > Product and category have a relationship of Multiple-to-Multiple. So > there is another association table named prod_in_cat: > pc_id pc_prod_id pc_cat_id > > I want to select a particular set of products along with one of its > categories in a single sql query, is that possible to implement it? > > > Thanks > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
