Re: help with SQL*Plus

This is of course possible by using the same table with another alias. Try this:

select txt1.descr, txt2.descr
from mydescr txt1, mydescr txt2, myid id where id.idcolumn1 = txt1.id and

      id.idcolumn2 = txt2.id;

this will work!

greetings,

Patrick Lapre(the netherlands). Received on Fri Sep 04 1998 - 16:10:38 CEST