Share
Explore BrainMass

Correction of Oracle9i Database

1. How can this be corrected?

2. Fix the view.

SELECT C.CLIENT_ID,
C.FIRST_NAME,
C.LAST_NAME,
COUNT(W.AD_ID) NUMBER_OF_ADS
FROM CLASSMATE.CLIENTS C JOIN CLASSMATE.WANT_AD W
ON C.CLIENT_ID = W.AD_OWNER
GROUP BY C.CLIENT_ID,
C.FIRST_NAME.
C.LAST_NAME

Solution Preview

SELECT C.CLIENT_ID,C.FIRST_NAME,C.LAST_NAME,COUNT(W.AD_ID) ...

Solution Summary

Oracle9i Database is emphasized.

$2.19