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: | 200210301321.05988.scott.taylor@4i-dotcom.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
Regards
Scott
From | Date | Subject | |
---|---|---|---|
Next Message | Mole | 2002-11-01 15:10:49 | Problem with LIKE in a SQL function |
Previous Message | Andrew McMillan | 2002-10-30 07:00:12 | Re: Working with timestamps and Unix Time |