MYSQL query

[Anon]

Does anyone know if this kind of query can be done and how? Thanks:

Lets say I have a table like such:
table1
ID Type
1 Type1
2 Type2
3 Type3

can I do a query using the same Type column, but return a different element in the SAME row. For example I would like to be able to see output like this:
+-----+------+------+
|Type | Type | Type |
+-----+------+------+
|Type1| Type2| Type3|
+-----+------+------+
1 row returned.

So I assume the SELECT query would look something like this:
SELECT Type, Type, Type FROM table1 ...etc

Does anyone know if it is possible to return multiple value from ONE column, but display it as one row? Thanks again.

[Anon]

You want to pull out the data as a single row? why? just pull it out and echo it as a single row:

<?
$result = mysql_query (SELECT Type from table);
while ($row = mysql_fetch_assoc ($result))
{
echo $row['type'] . ' ';
}
?>

[Anon]

Well, the problem is that I have 2 tables with data and one lookup table that are similar to this:
componenttype
+-----+----------+
| ID | Type |
+-----+----------+
| 1 | Device1 |
+-----+----------+
| 2 | Group1 |
+-----+----------+

component
+-----+------+-------------+
| ID |TypeID| Version |
+-----+------+-------------+
| 1 | 2 | 3.0.0 |
+-----+------+-------------+
| 2 | 2 | 3.0.1 |
+-----+------+-------------+
| 3 | 1 | 5.12.23 |
+-----+------+-------------+

lookup
+-----+------+
|GID | DID |
+-----+------+
| 1 | 3 |
+-----+------+

I want to return something like this:
+--------+-------+---------+---------+
| Type | G Ver | Type | D Ver |
+--------+-------+---------+---------+
| Group1 | 3.0.0 | Device1 | 5.12.23 |
+--------+-------+---------+---------+

I am trying to return which devices are part of which group, but my devices and groups are in the same table.

The lookup table says GID = 1 AND DID = 3. The query would SELECT elements from the component table (GID = 1 AND DID = 3) WHERE component.typeID = componenttype.ID
The problem is that I am trying to retrieve and display 2 different types from the componenttype table in the same row. Can this be done?