THIS CODE WORKS- select distinct emp.deptno, dname from emp,dept where dept.deptno=emp.deptno; BUT THIS WOULDNT select emp.deptno, distinct dname from emp,dept where dept.deptno=emp.deptno; ANY INSIGHTS?? Thanks.
Howdidly ho neighbo[u]r, and welcome to the Ranch! We hope you’ll enjoy pounding back pints of java help on a regular basis. However, we do have one piddly diddly little rule around these parts. Please change your display name to one that satisfies our piddly diddly little rule( naming policy - The skinny of the policy: just use a real firstname, followed by a space and a real lastname ). That's all! Thanks again and we hope to see you ordering up pints of java help on a regular basis! Jamie