Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vack
Aged Yak Warrior
530 Posts |
 Posted - 2009-04-17 : 10:55:05
|
| I am using the Import and Export Wizard. I am using this Statement to give me the data I want to export.select *from oelinhst_sqljoin oehdrhst_sql on oelinhst_sql.ord_no = oehdrhst_sql.ord_no and oelinhst_sql.inv_no = oehdrhst_sql.inv_nowhere year(oehdrhst_sql.inv_dt)>year(getdate())-3I am having the export wizard create the new table for me which is identitcal to the oelinhst_sql. I can hit the preview button and see the data I want on the Select Source Tables and Views screen. When I go to execute I get this message:There is more than one data source column with the name "ord_type" The data source column names must be unique" |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-17 : 11:13:18
|
| replace * with only columns you want. there may be same column coming from both tables which causes clash and produces this error. |
 |
|
|
|
|
|
Error Exporting Data