如何在sql server的Output中的Person表中显示国家名称和状态名称而不是ID。 [英] How to display Country Names and State Names instead of IDs in Person table in Output in sql server.
问题描述
我有3张桌子
1是个人
第二个是国家
和州
在个人表中,我维护了国家和州的ID这样的
ID姓名电子邮件CID SID MobileNo
0 a a 2 24 32322
1 4 4 4 4 4
2 qw qw 12 12 12
3 sd sd 3 3 3
4 4 4 4 4 4
我的问题是在显示人员表而不是CID和SID的输出时,我想显示两个表中的名称为此我写了这样的查询,但它没有显示正确的结果。
这是我的查询
I have 3 tables
1 is Person
2nd is Country
and State
In person table i have maintained ids of Country and State like this
ID Name Email CID SID MobileNo
0 a a 2 24 32322
1 4 4 4 4 4
2 qw qw 12 12 12
3 sd sd 3 3 3
4 4 4 4 4 4
My question is while displaying the output from person table instead of CID and SID i want to display their Names from both tables for that i have written query like this but it is not displaying proper result.
this is my Query
select condet.ContactID,condet.ContactName,condet.EMailID,tc.CName,ts.Name,condet.ContactNumber from tblContactDetails as condet
left outer join tblCountry as tc on condet.CountryID = tc.CountryID
left outer join tblState as ts on tc.CountryID = ts.CountryID
所以请建议我如何显示正确的结果而不重复。
So please suggest me how to display proper result with out duplicate.
推荐答案
好的它工作正常我必须在加入州子表时更改表名和列名。
Ok it is working fine just i have to change table and column name while joining the table of state child.
select condet.ContactID,condet.ContactName,condet.EMailID,tc.CName,ts.Name,condet.ContactNumber from tblContactDetails as condet
left outer join tblCountry as tc on condet.CountryID = tc.CountryID
left outer join tblState as ts on condet.stateid = ts.stateid
现在工作正常。
Now it is working fine.
这篇关于如何在sql server的Output中的Person表中显示国家名称和状态名称而不是ID。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!