C:\WebWork\mysql\bin>mysql --user=root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.0.20a-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select id from bugs.mantis_user_pref_table;
+----+
| id |
+----+
|  2 |
|  3 |
|  4 |
|  7 |
|  8 |
+----+
5 rows in set (0.05 sec)

mysql> select * from test.tt;
+------+
| x    |
+------+
|    1 |
|    2 |
+------+
2 rows in set (0.00 sec)

mysql> select id, x from test.tt, bugs.mantis_user_pref_table;
+----+------+
| id | x    |
+----+------+
|  4 |    1 |
|  4 |    2 |
|  2 |    1 |
|  2 |    2 |
|  3 |    1 |
|  3 |    2 |
|  8 |    1 |
|  8 |    2 |
|  7 |    1 |
|  7 |    2 |
+----+------+
10 rows in set (0.00 sec)

mysql>