SELECT [field list] FROM archivetable,currenttable WHERE
archivetable.username=currenttable.username
notes: can use join,left,right,select inside select aka subselect check
the manual for detail
Regards,
--
Aftab Jahan Subedar
Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha
Hi,
I have a table:
mysql describe archivetable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| sessionid | char(10) | | PRI |
Hi,
On Fri, Aug 01, 2003 at 11:55:36PM +0800, Jaime Teng wrote:
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;
* Jaime Teng
[...]
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;
+++-+-+