above is the code i'm using to select items from two tables
in the line item table there are 3 fiels - ORDER_NUMBER,PART_NUMBER + QTY! for every order number there is a part number and quantity so i want to print out all the items associated with a certain order number eg. ORDER NUMBER 43567 has: PART NUMBER QB-101, QTY 4 PART NUMBER QB-102, QTY 1
but when i want to print out these two part numbers it only prints out the first one. I've tried different things but i cant get more than one item to be printed out..Can anyone help?