Select error?

Neba · #1 (**permalink**) 03-03-04, 05:18

Hi can someone tell me what is wrong with the following statement.

SQL> select mcode, mname, avg(cmark) from result, module
2 where result.mcode = module.mcode
3 order by cmark desc;

select mcode, mname, avg(cmark) from result, module
*
ERROR at line 1:
ORA-00918: column ambiguously defined

thanx

Littlefoot · #2 (**permalink**) 03-03-04, 06:19

SQL> select mcode, mname, avg(cmark) from result, module
2 where result.mcode = module.mcode
3 order by cmark desc;

Column mcode (or all of them) exists in both of the tables, and it is unknown which one of those you want to select. Obviously, the result will be the same, but you have to specify the table (or its alias), such as

PHP Code:


			
select r.mcode, m.mname, avg(r.cmark)

from result r, module m

where r.mcode = m.mcode

order by r.cmark desc;

Neba · #3 (**permalink**) 03-03-04, 07:18

ok than for the reply.

Internet Services

Web Development

Digital Marketing

Consumer Tech