Skip site navigation (1) Skip section navigation (2)

PgAccess Visual Query

From: Scott Taylor <scott(dot)taylor(at)4i-dotcom(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PgAccess Visual Query
Date: 2002-10-30 13:21:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Could someone tell me the syntax for the "Criteria" box for the following 

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



pgsql-novice by date

Next:From: MoleDate: 2002-11-01 15:10:49
Subject: Problem with LIKE in a SQL function
Previous:From: Andrew McMillanDate: 2002-10-30 07:00:12
Subject: Re: Working with timestamps and Unix Time

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group