RE: Database Question

[paul smith]

Thanks!

best,  paul

At 09:26 PM 3/20/01 -0500, you wrote:
>I think you're looking for:
>
>INSERT INTO MtTable3 (ID)
>SELECT ID FROM MyTable1 WHERE SpecialID=3
>
>It's as simple as that,
>Bob


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists