<div>
for such condition you may use two joins as<br />
<br />
Select * from yourTable<br />
Inner Join tbl as Country On yourCondion<br />
Inner Join tbl Nationailty &nbsp;On yourCondion<br />
<br />
<br />
if your data can be null then use left outer join as <br />
<br />
Select * from yourTable<br />
Left Outer Join tbl as Country On yourCondion<br />
Left Outer Join tbl Nationailty &nbsp;On yourCondion<br />

</div>


for such condition you may use two joins as

Select * from yourTable
Inner Join tbl as Country On yourCondion
Inner Join tbl Nationailty  On yourCondion


if your data can be null then use left outer join as

Select * from yourTable
Left Outer Join tbl as Country On yourCondion
Left Outer Join tbl Nationailty  On yourCondion


<div>
Perfect. Thanks mate. Did not know that you could join the same table more then once.
</div>


Perfect. Thanks mate. Did not know that you could join the same table more then once.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to wirte an sql query that pulls out info on clients. Now for each client record I have 2 codes for the countryID and nationalityID. I need to display both of them.<br />
<br />
The problem I have is that these two fields point to the same table holding the data i need, As an example, assume I have the following:<br />
<br />
ID 1 County Mallta Nationality Maltese<br />
ID 2 Country UK Nationality British<br />
<br />
Now I can have a client with a street address pointing to countryID 1, that is Malta, but a nationalituID of 2 = British.<br />
<br />
Since now via left joins I added the country to the records I need to pull, but now I am stcuk as I want to add the nationality too.<br />
<br />
Any Help is welcome, if you need further detail please just ask.
</div>
</div>


Hi,

I need to wirte an sql query that pulls out info on clients. Now for each client record I have 2 codes for the countryID and nationalityID. I need to display both of them.

The problem I have is that these two fields point to the same table holding the data i need, As an example, assume I have the following:

ID 1 County Mallta Nationality Maltese
ID 2 Country UK Nationality British

Now I can have a client with a street address pointing to countryID 1, that is Malta, but a nationalituID of 2 = British.

Since now via left joins I added the country to the records I need to pull, but now I am stcuk as I want to add the nationality too.

Any Help is welcome, if you need further detail please just ask.

SQL Query Question

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.