select t1.field, t2.field
from table t1, table t2
where t1.field < t2.field
"Kamal" <kamal80_at_virgilio.it> wrote in message
news:4e766a02.0304010849.5af9a38d_at_posting.google.com...
> Hi everybody.
>
> I have a table with one column with a string datatype.
> I have four records in this table.
>
> car
> home
> dog
> woman
>
> I want to obtain this from a query on this table:
>
> car home
> car dog
> car woman
> home dog
> home woman
> dog woman
>
> How would you do it in pure SQL?
> (Or if you can't, in Oracle, but always with a single query)
>
> Thank you.
>
> Kamal
Received on Wed Apr 02 2003 - 04:39:19 CST
