try puttind an alias on the sub-select in the where clause
eg WHERE DeviceStaging.MacAddress NOT IN (
SELECT ma2.MacAddress
FROM MacAddress ma2)
On 4/23/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]>
wrote:
>
> Thanks AJ, That's all sorted now. :-D
>
> Next part of my query is now causing problems (again with no CF error,
> Doh!)
> I'm trying to move all mac address's that don't currently exists in the
> MacAddress table from the DeviceStaging table.
>
> INSERT INTO MacAddresses (MacAddress, Port)
> SELECT DeviceStaging.MacAddress, DeviceStaging.Port
> FROM DeviceStaging
> WHERE DeviceStaging.MacAddress NOT IN (SELECT MacAddress
> FROM MacAddress)
>
> Any ideas why this won't run? When placing it through query analyzer it
> tells me:
>
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'DeviceStaging'.
>
> But I defiantly have a table called DeviceStaging as that's where the
> import
> happens.
>
> Thanks,
>
> Rob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276048
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
