سلام

یه مشکلی داشتم ، امیدوارم که کمکم کنید.

تو جدولی فیلد استان سکونت و استان محل کار دارم

که به جدول استان وصله و ارتباط دارد.در واقع 2 تا فیلد از این جدول foreign key داره با جدول استان

حالا میخوام به جوین این جدولا اسم استان محل سکونت و کار بیاورد

مشکل اینه که اسم محل سونت میاره !

اما استان محل کار نمیاره!!!!!!!!!!1

امیدوارم که وقت داشته باشید تا کمکم کنید

جداول :

CREATE TABLE [dbo].[person](
	[UserName] [int] NOT NULL,
	[OstanW] [int] NULL,
	[OstanSokonat] [int] NULL,
	[cityw] [int] NULL,
	[citysokonat] [int] NULL,
 CONSTRAINT [PK_person] PRIMARY KEY CLUSTERED 
(
	[UserName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[person]  WITH CHECK ADD  CONSTRAINT [FK_person_city] FOREIGN KEY([cityw])
REFERENCES [dbo].[city] ([id])
GO

ALTER TABLE [dbo].[person] CHECK CONSTRAINT [FK_person_city]
GO

ALTER TABLE [dbo].[person]  WITH CHECK ADD  CONSTRAINT [FK_person_city1] FOREIGN KEY([citysokonat])
REFERENCES [dbo].[city] ([id])
GO

ALTER TABLE [dbo].[person] CHECK CONSTRAINT [FK_person_city1]
GO

ALTER TABLE [dbo].[person]  WITH CHECK ADD  CONSTRAINT [FK_person_ostan] FOREIGN KEY([OstanW])
REFERENCES [dbo].[ostan] ([id])
GO

ALTER TABLE [dbo].[person] CHECK CONSTRAINT [FK_person_ostan]
GO

ALTER TABLE [dbo].[person]  WITH CHECK ADD  CONSTRAINT [FK_person_ostan1] FOREIGN KEY([OstanSokonat])
REFERENCES [dbo].[ostan] ([id])
GO

ALTER TABLE [dbo].[person] CHECK CONSTRAINT [FK_person_ostan1]
GO




SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[city](
	[id] [int] NOT NULL,
	[namec] [nchar](10) NULL,
 CONSTRAINT [PK_city] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO




SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ostan](
	[id] [int] NOT NULL,
	[ostans] [nvarchar](50) NULL,
 CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]