Trying to retrive order details and print out multple orders
have three tables orders, partdetails, transactiondetail, trying to create
a query to print out multiple orders in this fashion
Order#1 table orders
Part1 2@ 5.00 10.00 Part2 1@ 4.00 4.00 table partdetails Part3 3@ 3.00 9.00
Tax Rate 8.25 Subtotal 23.00 Sales Tax 1.90 table orders Total 24.90
payment tendered Change MC 10.00 0 table transactiondetails cash 14.90 0
Order#2 table orders
Part1 2@ 5.00 10.00 Part2 1@ 4.00 4.00 table part details Part3 3@ 3.00 9.00
Tax Rate 8.25 Subtotal 23.00 Sales Tax 1.90 table orders Total 24.90
payment tendered Change MC 10.00 0 table transactiondetail cash 14.90 0
Order#3 ''
Part1 2@ 5.00 10.00 Part2 1@ 4.00 4.00 '' Part3 3@ 3.00 9.00
Tax Rate 8.25 Subtotal 23.00 Sales Tax 1.90 '' Total 24.90
payment tendered Change MC 10.00 0 '' cash 14.90 0