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 -~----------~----~----~----~------~----~------~--~---
