var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sqlplus queries problem.... [urgent]
hi i'm new to SQL plus queries statement and i have the foloowing query that doesnt seems to work well...
SELECT C.CUST_ID, P.SERVICE_TOTAL, O.ORDER_TOTAL, E.SERVICE_NUMBER, E.SERVICE_DESC
FROM CUSTOMER C, PAYMENT P, ORDERS O, EXTENDED_SERVICE E, RESERVATION R, CHECK_IN I, ORDER_LINE N, MEMBERSHIP M
error occur when i try to use 'HAVING ORDER>50.00"...... CAN ANYBODY KNOW HOW TO SOLVE THIS PROBLEM ??
If you are using SQL*Plus (which is Oracle) why do you post in the MySQL forum?
To add a condition on a specific column you need to use WHERE order_total > 50.
Having is for conditions on groups (created by GROUP BY).