"Jigal van Hemert" <[EMAIL PROTECTED]> wrote on 01/24/2005 03:10:40 AM:
> > so it will be like this
> > no date price limit
> > 01 1/1/05 5000 100
> > 02 1/2/05 5010 100
> > 03 1/3/05 5020 60 **
> > 04 1/6/05 5010 100 ** there are 3 days difference
> >
> > but how do make a query to check for rec
> so it will be like this
> no date price limit
> 01 1/1/05 5000 100
> 02 1/2/05 5010 100
> 03 1/3/05 5020 60 **
> 04 1/6/05 5010 100 ** there are 3 days difference
>
> but how do make a query to check for record no 04 with 03
> how do i retrieved the 1/3/05 date and the price
You actually want t
-- Forwarded message --
From: Chenri <[EMAIL PROTECTED]>
Date: Mon, 24 Jan 2005 08:22:01 +0700
Subject:
To: mysql@lists.mysql.com
i have a price table
no date price limit
01 1/1/05 5000 100
02 1/2/05 5010 100
03 1/3/05 5020 60
in order to input a record the price must be checke
