mysql> select * from coordsys;
+-------------+--------------------------------+
| ID_COORDSYS | COORDSYS_NAME                  |
+-------------+--------------------------------+
|           1 | Solar Disc                     |
|           2 | Heliographic                   |
|           3 | Heliocentric Ecliptic          |
|           4 | Geocentric Inertial            |
|           5 | Geocentric Solar Magnetosferic |
|           6 | Galactic                       |
|           7 | SOHOcentric Ecliptic           |
|          10 | SDC                            |
|          11 | Solar Disc Polar               |
|          12 | N/A                            |
|          13 | Solar Cropped                  |
+-------------+--------------------------------+
11 rows in set (0.02 sec)

mysql> select 'test' from coordsys;
+------+
| test |
+------+
| test |
| test |
| test |
| test |
| test |
| test |
| test |
| test |
| test |
| test |
| test |
+------+
11 rows in set (0.00 sec)

mysql> select * from coordsys;
+-------------+--------------------------------+
| ID_COORDSYS | COORDSYS_NAME                  |
+-------------+--------------------------------+
|           1 | Solar Disc                     |
|           2 | Heliographic                   |
|           3 | Heliocentric Ecliptic          |
|           4 | Geocentric Inertial            |
|           5 | Geocentric Solar Magnetosferic |
|           6 | Galactic                       |
|           7 | SOHOcentric Ecliptic           |
|          10 | SDC                            |
|          11 | Solar Disc Polar               |
|          12 | N/A                            |
|          13 | Solar Cropped                  |
+-------------+--------------------------------+
11 rows in set (0.00 sec)

mysql> select *,'test' from coordsys;
+-------------+--------------------------------+------+
| ID_COORDSYS | COORDSYS_NAME                  | test |
+-------------+--------------------------------+------+
|           1 | Solar Disc                     | test |
|           2 | Heliographic                   | test |
|           3 | Heliocentric Ecliptic          | test |
|           4 | Geocentric Inertial            | test |
|           5 | Geocentric Solar Magnetosferic | test |
|           6 | Galactic                       | test |
|           7 | SOHOcentric Ecliptic           | test |
|          10 | SDC                            | test |
|          11 | Solar Disc Polar               | test |
|          12 | N/A                            | test |
|          13 | Solar Cropped                  | test |
+-------------+--------------------------------+------+
11 rows in set (0.00 sec)

mysql> select 'test', * from coordsys;
ERROR 1064 (00000): You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '* from coordsys' at line 1

##</code><code>##

mysql> create table temp_table_name ( test varchar(4) );
Query OK, 0 rows affected (0.00 sec)

mysql> select temp_table_name.*, coordsys.* from coordsys left outer join temp_table_name on temp_table_name.test = coordsys.id_coordsys;
+------+-------------+--------------------------------+
| test | ID_COORDSYS | COORDSYS_NAME                  |
+------+-------------+--------------------------------+
| NULL |           1 | Solar Disc                     |
| NULL |           2 | Heliographic                   |
| NULL |           3 | Heliocentric Ecliptic          |
| NULL |           4 | Geocentric Inertial            |
| NULL |           5 | Geocentric Solar Magnetosferic |
| NULL |           6 | Galactic                       |
| NULL |           7 | SOHOcentric Ecliptic           |
| NULL |          10 | SDC                            |
| NULL |          11 | Solar Disc Polar               |
| NULL |          12 | N/A                            |
| NULL |          13 | Solar Cropped                  |
+------+-------------+--------------------------------+
11 rows in set (0.00 sec)

##</code><code>##

SQL> select 'test',coordsys.* from soho.coordsys;

'TES ID_COORDSYS COORDSYS_NAME
---- ----------- --------------------------------------------------
test           1 Solar Disc
test           2 Heliographic
test           3 Heliocentric Ecliptic
test           4 Geocentric Inertial
test           5 Geocentric Solar Magnetosferic
test           6 Galactic
test           7 SOHOcentric Ecliptic
test          10 SDC
test          11 Solar Disc Polar
test          12 N/A
test          13 Solar Cropped

11 rows selected.