Hi all,
I woould like to insert data into a table from another table, but the
final table has an extra field as follows:
[ Table]
Name
Comp
Description
Flag
[New Table]
Name
Comp
Description
Flag
[Date]
Because of the extra [Date] field, I am unable to use the following
statement: "Insert INT [New Table] Select Name, CompRefNo,
CompId, Description, Flag from [ Table] Where Flag = ''".
I am using VB6 and SQL Server 2000 Database.
Any suggestion would be highly appreciated. Thanking you all in advance.
Regards,
Peter Mugoh
Yahoo! Groups Links
<*To visit your group on the web, go to:
<*Your email settings:
Individual Email | Traditional
<*To change settings online go to:
(Yahoo! ID required)
<*To change settings via email:
@yahoogroups.com
@yahoogroups.com
<*To unsubscribe from this group, send an email to:
@yahoogroups.com
<*Your use of Yahoo! Groups is subject to: