You have ZIPs with leading zeros.. which means they are characters, not numbers
have you tried
IN ('00000','00001','00002')...
Plus you wouldn't necessarily need 2 queries..
A subquery would work..
select * from tbl_a where col in (select * from tbl_2)...
Or course I'd probably use exists if your inner query returned a lot
of records..
select * from tbl_a a
where exists (
select 1 from tbl_b b
where a.col = b.col
)
On Tue, May 20, 2008 at 12:34 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Does anyone have any ideas on this? Thanks.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305755
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
