[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] PgAccess Visual Query
From:       Brett Schwarz <brett_schwarz () yahoo ! com>
Date:       2002-10-31 5:34:11
[Download RAW message or body]

It is anything that would follow a WHERE clause. So, for #2, in the
Criteria entry for that field, you would put:

    = 10074

Hence, the full query would look like this then (when it gets executed):

   SELECT * FROM some_table WHERE Chart_ID = 10074

HTH,

    --brett


On Wed, 2002-10-30 at 13:51, Scott Taylor wrote:
> Could someone tell me the syntax for the "Criteria" box for the following
> commands:
> 
> 1. (Date column) Dates between 01-07-2002 and 30-09-2002
> 2. (Chart_ID column) Where value=10074
> 3. (Trans_ID column which has 3 entries with same ID, but only one would
> have a Chart_ID of 10074) If entry has a Chart_ID value of 10074, return
> all the rows EXCEPT the actual entry with Chart_ID=10074
> 
> So the query should return this with the amount column split
> 
> Date			Chart_ID		Trans_ID		Amount	Amount	Amount
> 
> 01-07-2002	10074		45689		15
> 01-07-2002				45689				100
> 01-07-2002				45689						115
> 
> Did that make sense?
> 
> Regards
> 
> Scott
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
-- 
Brett Schwarz
brett_schwarz AT yahoo.com


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]