|
|
Wednesday, April 02, 2003
|
|
| |
Query to get count distinct hunting license holders from Electronic License System data:
SELECT COUNT(DISTINCT CUST)
FROM
(SELECT CUST_NAME||CUST_STREET as CUST
FROM TXNLICENSE_HISTORY A, ELS_CUSTOMER B
WHERE A.TXNL_YEAR = 2001 AND A.TXNL_LICN_TYPE IN
( 211,100,216,217,212,210,213,215,219,224,660,610,650,221,222,223,235,225,661,611,651,228)
AND A.TXNL_CUST_ID = B.CUST_ID
AND A.TXNL_STATUS = 'A')
answer = 584702
1:02:34 PM
|
|
|
|
© Copyright
2003
mcgyver5.
Last update:
8/14/2003; 1:43:56 AM.
This theme is based on the SoundWaves
(blue) Manila theme. |
|
| April 2003 |
| Sun |
Mon |
Tue |
Wed |
Thu |
Fri |
Sat |
| |
|
1 |
2 |
3 |
4 |
5 |
| 6 |
7 |
8 |
9 |
10 |
11 |
12 |
| 13 |
14 |
15 |
16 |
17 |
18 |
19 |
| 20 |
21 |
22 |
23 |
24 |
25 |
26 |
| 27 |
28 |
29 |
30 |
|
|
|
| Mar May |
|