| Author |
 Topic  |
|
|
calvinkwoo3000
Yak Posting Veteran
Singapore
88 Posts |
 Posted - 05/10/2012 : 03:31:20
|
Table A
-----------------------
Proj_Code Proj_desc
AAAAAAAA description
Table_Member
------------------------
Proj_Code MemberName
AAAAAAAA Name1
AAAAAAAA Name2
I want result as below:
Proj_Code Proj_desc MemberName
AAAAAAAA description Name1, Name2
Please Help, thank you.
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 05/10/2012 : 03:34:43
|
So, how does your current code look like?
N 56°04'39.26"
E 12°55'05.63" |
 |
|
|
calvinkwoo3000
Yak Posting Veteran
Singapore
88 Posts |
Posted - 05/10/2012 : 03:38:32
|
quote:
Originally posted by SwePeso
So, how does your current code look like?
N 56°04'39.26"
E 12°55'05.63"
Select Proj_Code, Proj_desc, MemberName as
(Select MemberName from Table_Member M
where M.Proj_Code = A.Proj_Code)
from table A |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
|
|
calvinkwoo3000
Yak Posting Veteran
Singapore
88 Posts |
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
Posted - 05/10/2012 : 05:30:37
|
welcome
KH
Time is always against us
|
|
|
| |
Topic |
|
Subquery returned more than 1 value
