No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Re:
hello, could u pls tell me if there's any function which can allow java to decide what operator should use in order to return a min/max number? if yes.. i'd be happy to see it. i once saw something like this: [I]use "+,-,/" [/I].. followed by i don't know what.. … |
|
Re:
I am trying to use this syntax to no avail: [code=sql]SELECT C_Name, ORDERS.O_ID, SUM(ITEM_ORDERED.QUANTITY*PRODUCT.P_PRICE) AS TOTAL_PRICE FROM CUSTOMER, ORDERS, ITEM_ORDERED, PRODUCT WHERE CUSTOMER.C_ID=ORDERS.C_ID AND ORDERS.O_ID=ITEM_ORDERED.O_ID AND ITEM_ORDERED.P_ID=PRODUCT.P_ID GROUP BY ORDERS.O_ID;[/code] My 4 tables would look like this: [U]customer[/U] [U]order[/U] [U]item_ordered[/U] [U]Product[/U] PK C_ID PK O_ID PK,FK O_ID PK P_ID C_Name … |