Returing multiple rows based on 2 criteria
Posted by:
chris d
Date: December 09, 2012 07:04PM
Hey guys,
For my senior project, im making a web app for deli food orders. This consists of a database containing the following tables:
customer PK custID
inventory PK inventoryID
item PK itemID
item_type PK itemTypeID
order PK orderID
order_line PK orderLineID PK FK orderID
So basically theres a M-M relationship between the table ORDER and ITEM. The conjoining table is ORDER_LINE.
I want to be able to RETURN each consecutive row in ORDER_LINE that belongs to a particular orderID.
Thanks in advance!
Subject
Written By
Posted
Returing multiple rows based on 2 criteria
December 09, 2012 07:04PM
December 09, 2012 08:43PM
December 09, 2012 10:17PM
December 09, 2012 10:29PM
December 09, 2012 10:36PM
December 09, 2012 10:56PM
December 09, 2012 11:03PM
December 09, 2012 11:06PM
December 09, 2012 11:08PM
December 10, 2012 01:46PM
December 10, 2012 03:08PM
December 10, 2012 03:28PM
December 10, 2012 06:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.