ambiguous column name - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

ambiguous column name

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-07-13 : 07:53:31

Dear experts,
while i'm trying to insert data , i got error like
Ambiguous column name...that is related to joins
the query is
INSERT INTO MATABLE044
SELECT newid(), ledger.COLUMN002, wh.COLUMN001, Loc.COLUMN005, ledger.COLUMN008, ledger.COLUMN009, ledger.COLUMN010, ledger.COLUMN011,0,
1-1-1900, ledger.COLUMN006, ledger.COLUMN007, ledger.COLUMN014, 'Y', ledger.column016,ledger.COLUMN020, ledger.COLUMN021, ledger.COLUMN022,ledger.COLUMN023,
ledger.COLUMN024,ledger.COLUMN025,ledger.COLUMN026,ledger.COLUMN027,Loc.COLUMN005,ledger.COLUMN029,ledger.COLUMN030,ledger.COLUMN002EE,
'NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','SNSP_BRANCH','SNSP_BRANCH','SNSP_USER',convert(varchar(19),getdate(),120),NULL,convert(varchar(19),getdate(),120),newid(),'DBMS_REPUTIL.GLOBAL_NAME','en'

FROM MATABLE043 ledger
Inner JOIN MATABLE012 wh on ledger.column002 = wh.column002
Inner JOIN MATABLE024 Loc on wh.column001 = loc.column004
WHERE COLUMN002 ='c5a0bcc4-743a-4d9a-80a5-7c2ebbf6deec' and COLUMN006 = '3d42a36e-7df7-41cd-a6ee-189f4e3f2ad5'
AND COLUMN009 NOT IN ( SELECT COLUMN006 FROM MATABLE044)

what is the meaning

thank you very much

Vinod
Even you learn 1%, Learn it with 100% confidence.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-13 : 07:56:12

You have several columns used, such as COLUMN002 and COLUMN009 where you have not prefixed with table name.

Peter Larsson
Helsingborg, Sweden

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-07-13 : 08:36:40

also, are you aware that this:

select 'NULL'

is not the same as this:

select NULL

??

EDIT: also, it's not surprising that you are getting confused with column names like COLUMN002, etc. Do you ever find yourself wondering which column has which data in it?

Do you name variables like that too? declare @nvarchar100 nvarchar(100)...

elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources