Obtaining two rows from two different columns in same table

From: MacMax <macmax_at_nospam.it>
Date: Wed, 29 Apr 2015 17:20:27 +0200
Message-ID: <1m3ngyd.z05jd3b6oxu6N%macmax_at_nospam.it>



Someone can help me?

In one table (rel) i have this structure. All three fields are numeric.

id, co1, co2

In another table (users) i have the names... id_co, name
id_co, name
etc.

I would like this result:

id, name (co1)
id, name (co2)

How i can get this?

Thanks in advance

Max

-- 
http://www.maxori.it
L'Arte è la capacità di fare cose di nessun valore
e di riuscire a venderle
F. Zappa
Received on Wed Apr 29 2015 - 17:20:27 CEST

Original text of this message