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 #
* 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;
> +++-+---
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;
> ++--
Hi,
I have a table:
mysql> describe archivetable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| sessionid | char(10) | | PRI |
