help with SQL*Plus

From: Rob Mason <rmason_at_cellularsouth.net>
Date: 1998/09/04
Message-ID: <35EFE810.E3A0675B_at_cellularsouth.net>#1/1

I have a table that has an ID in multiple columns and the description of those ID's in another table. What is the best method (using SQL*Plus) that will allow me to display the text description on the same line with other text descriptions of ID's in the same row?

For example:

select txt.descr, txt.descr
from mydescr txt, myid id
where id.idcolumn1=txt.id
or id.idcolumn2=txt.id;

mydescr

---

1 Description 1
2 Description 2
3 Description 3

myid

---

1
2
3

Does this make sense?

Thanks in advance for any help

Rob Mason
rmasonjr_at_cellularsouth.com Received on Fri Sep 04 1998 - 00:00:00 CEST