Getting an error while extracting the data from database
a
anonymous
started a topic
over 11 years ago
[This topic is migrated from our old forums. The original author name has been removed]
Hi Team,
I am having an unique numbers in my table, after running the query getting multiple entries for those unique no's tasks. Need your help to get the single entry in a row with multiple tasks. please refer the below given e.g.
Current Extract in a query
Unique No. Tasks
1001 excel
1001 word
1003 powerpoint
1003 word
1004 access
1004 sql
1005 sql
1005 word
Need an extract as per the below given table
Unique No. Tasks
1001 excel,word
1003 powerpoint,word
1004 access,sql
1005 sql,word
1 Comment
Roger Bjärevall
said
over 11 years ago
[This reply is migrated from our old forums.]
Re: Getting an error while extracting the data from database
Hi,
Please check the following:
http://www.dbvis.com/forum/message.jspa?messageID=15653
You need to consult the capabilities of the database you are using.
Regards
Roger
anonymous