SELECT *
FROM
WHERE value > 915
-Original Message-
From: delz [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 9:46 AM
To: [EMAIL PROTECTED]
Subject: Help in querying
Hi All,
I'm using mysql as my database. I have a table which has the following
colums:
idx
pro
Hi All,
I'm using mysql as my database. I have a table which has the following
colums:
idx
productname
value
My question is how do i display and select all the data that has a value of
more than 915.
Hope you can help.
Regards,
Delz
--
MySQL General Mailing List
For list archives: http://
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 |
