Reg : Query

Question

User830885794 posted

I am using select statement and using join with some tables my query output is like below

ID      Code    Email

AA24 Au      [e-mail]

AA24 Au      [e-mail]

AA24 Au      [e-mail]

MS61 Ag      [e-mail]

MS61 Ag      [e-mail]

MS61 Ag      [e-mail]

MS61 Ag      [e-mail]

If u look, only the Email column varies. I want my output like this

ID      Code    Email

AA24 Au      [e-mail]; [e-mail]; [e-mail]

MS61 Ag      [e-mail]; [e-mail]; [e-mail]; [e-mail]

How to get output like above. do i need to use a function for printing the email id or without function can i do ?

any ideas

I am using select statement and using join with some tables my query output is like below

ID          Code       Email

AA24 Au      [e-mail]

AA24 Au      [e-mail]

AA24 Au      [e-mail]

MS61 Ag      [e-mail]

MS61 Ag      [e-mail]

MS61 Ag      [e-mail]

MS61 Ag      [e-mail]

If u look, only the Email column varies. I want my output like this

ID          Code                      Email

AA24 Au      [e-mail]; [e-mail]; [e-mail]

MS61 Ag      [e-mail]; [e-mail]; [e-mail]; [e-mail]

How to get output like above. do i need to use a function for printing the email id or without function can i do ?

any ideas

Answer 1

User-1952482173 posted

Pick one solution from here

 http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Answer 2

User-1199946673 posted

Pick one solution from here

 http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

 

This quesion is being asked in the Access Databases and AccessDataSource Forum! Your solution won't work in Access/Jet!

How to get output like above. do i need to use a function for printing the email id or without function can i do ?

 

This is not possible in Access (Jet) SQL. You need to retrieve the records like you have them using a datareader, and then loop through the records in code to get the desired output