|
Posted by figital on 03/20/06 16:18
Clare,
You usually can't just take pieces of a large query and expect them to
work all by themselves.
What is this in the 3rd line, from your post at Sat, Mar 18 2006 2:20
pm?:
SELECT polid. polexpdate =MAX (polexpdate)
FROM afw_basicpolinfo p WHERE p.polno like '1932700%'
GROUP BY polid AS p1 ON p1.polid-p1 p1 polid -- <-- what is this?!
Join afw_basicpolinfo p on p.polid = p1.polid
AND p.polexpdate=p1.polexpdate
WHERE p.polexpdate between '2006-04-15 00:00:00.000 and 2006-04-31
00:00:00.000'
and c.email IS NOT NULL
I have never seen syntax like that before.
Navigation:
[Reply to this message]
|