simple Query error

Question

simple Query error

varunkum

Default port

Points: 1481
More actions
December 22, 2010 at 1:47 pm

#232280

select * from CIRC.SUBS_TAG a, DSIPROC.TRB_VW_SUBS_INFO b, CIRC.TAG c
where a.ACCOUNT= b.ACCOUNT and a.CODE=c.CODE
I typed this in the query field of Dataset and i get the following error
<Field 12>
More than one item has the name 'ACCOUNT'.
Someone please help me why am i getting this error. Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

LutzM SSC Guru Points: 107049 More actions · Answer 1

Instead of using SELECT * you'd need to specify each column and use alias column names for the duplicates (like a.ACCOUNT, b.ACCOUNT, a.COD, c.CODE and maybe some more columns).

The reason is rather simple: SSRS needs unique column names to identify each column. It's the same like creating a view.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

varunkum Default port Points: 1481 More actions · Answer 2

LutzM (12/22/2010)
Instead of using SELECT * you'd need to specify each column and use alias column names for the duplicates (like a.ACCOUNT, b.ACCOUNT, a.COD, c.CODE and maybe some more columns).
The reason is rather simple: SSRS needs unique column names to identify each column. It's the same like creating a view.

@LutzM:Thank you so much