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.
| Author |
Topic |
|
desikankannan
Posting Yak Master
152 Posts |
 Posted - 2013-11-12 : 23:06:50
|
| I have two tables tbldeathdata and guestbook will multiple id , i want to match id and give the record , below is my tried querySELECT lastname+'-'+ Firstname FROM deathdata a where a.id = (select id from GuestBook)errorsg 512, Level 16, State 1, Line 2Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.Desikankannan |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2013-11-12 : 23:12:40
|
[code]SELECT a.lastname + '-' + a.Firstname FROM deathdata a inner join GuestBook b on a.id = b.idwhere a.id = (select id from GuestBook)[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
left join