003 10:06 AM
To: [EMAIL PROTECTED]
Cc: Admin-Stress
Subject: Re: help on my query statement
* Admin-Stress
> I have a table called TRANSACTION, it has some fields :
>
> REGDATE - date of the transaction
> WHAT - a string (NOT UNIQUE)
> CUSTOMER - customer code
>
> I want to q
* Admin-Stress
> I have a table called TRANSACTION, it has some fields :
>
> REGDATE - date of the transaction
> WHAT - a string (NOT UNIQUE)
> CUSTOMER - customer code
>
> I want to query all WHAT that the date of the transaction was 15
> days before.
>
> So, my sql query is :
>
> SELECT WHAT FROM
I have a table called TRANSACTION, it has some fields :
REGDATE - date of the transaction
WHAT - a string (NOT UNIQUE)
CUSTOMER - customer code
I want to query all WHAT that the date of the transaction was 15 days before.
So, my sql query is :
SELECT WHAT FROM TRANSACTION WHERE REGDATE < Now()
