Need help in querying two tables

[Jaime Teng]

Hi,

I have a table:

mysql> describe archivetable;
+-----------+----------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------------------+-------+
| sessionid | char(10) | | PRI | | |
| username | char(25) | | MUL | | |
| logon | datetime | | MUL | 0000-00-00 00:00:00 | |
| logoff | datetime | | MUL | 0000-00-00 00:00:00 | |
+-----------+----------+------+-----+---------------------+-------+

Whenever I do a query, I get results in this format:

mysql> select * from archivetable;
+------------+------------+---------------------+---------------------+
| sessionid | username | logon | logoff |
+------------+------------+---------------------+---------------------+
| 0000000003 | dangco77 | 1996-09-25 20:51:59 | 1996-09-25 21:07:00 |
| 0000000006 | mccarthy | 1996-09-26 06:15:35 | 1996-09-26 06:20:00 |
| 0000000007 | sigmaph | 1996-09-26 06:25:48 | 1996-09-26 06:28:00 |
| 0000000009 | sigmaph | 1996-09-26 08:31:53 | 1996-09-26 08:51:00 |
+------------+------------+---------------------+---------------------+

Now, I have two of these tables (archivetable,currenttable).

My problem is how do I perform a single query such that I get
results from these two tables:

mysql> select * from archivetable,currenttable;
+------------+------------+---------------------+---------------------+
| sessionid | username | logon | logoff |
+------------+------------+---------------------+---------------------+
| 0000000003 | dangco77 | 1996-09-25 20:51:59 | 1996-09-25 21:07:00 |
| 0000000006 | mccarthy | 1996-09-26 06:15:35 | 1996-09-26 06:20:00 |
| 0000000007 | sigmaph | 1996-09-26 06:25:48 | 1996-09-26 06:28:00 |
| 0000000009 | sigmaph | 1996-09-26 08:31:53 | 1996-09-26 08:51:00 |
| 1000265891 | okame | 2003-08-01 13:38:24 | 2003-08-01 13:43:42 |
| 1000265893 | kbs | 2003-08-01 13:38:30 | 2003-08-01 13:38:48 |
| 1000265897 | bdo-albaro | 2003-08-01 13:38:54 | 2003-08-01 14:07:06 |
+------------+------------+---------------------+---------------------+

of course that last query isnt correct but thats the result I want.

any suggestion? I read about using JOIN but I have no idea how to\
make it work for my need.

hoping for your help.

Jaime
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw