I have two SQL queries that call the same table but with different where statements.

How can I incorporate the following 2 SQL queries together, so that the LanguageAvailableDescriptionIntl value in the 2nd query replaces the LanguageAvailableDescriptionIntl values in the 1st query?

1st SQL Query

SELECT 
LanguageVersion.LanguageVersionID, 
(LanguageDetail.LanguageDetailDescriptionIntl + ' - ' + Country.CountryShortNameIntl) as LanguageAvailableDescriptionIntl, 
CountryFlag.CountryFlagIconPath 

FROM 
LanguageVersion, 
LanguagesAvailable, 
Country, 
CountryFlag, 
LanguageDetail

WHERE LanguageVersion.LanguageAvailableID = LanguagesAvailable.LanguageAvailableID 
AND LanguagesAvailable.CountryID = Country.CountryID 
AND Country.CountryFlagID = CountryFlag.CountryFlagID 
AND LanguageVersion.UserID = @UserID 
AND LanguagesAvailable.LanguageDetailID = LanguageDetail.LanguageDetailID 

ORDER BY LanguageAvailableDescriptionIntl ASC

1st SQL Query Output

LanguageVersionID    LanguageAvailableDescriptionIntl         CountryFlagIconPath
---------------------------------------------------------------------------------------

1536                 Deutsch – Deutschland                           ~/Images/Flags/138.gif

1625                 English (US) - Australia                 ~/Images/Flags/36.gif

1532                 Español - España                         ~/Images/Flags/177.gif

1534                 Français - France                        ~/Images/Flags/116.gif

1612                 Polski - Polska                          ~/Images/Flags/147.gif

1621                 Ελληνικά - Ελλάδα                        ~/Images/Flags/142.gif

1613                 עבֿרית - ישראל                            ~/Images/Flags/9.gif

1614                 فارسی - ایران                            ~/Images/Flags/237.gif

1618                 हिन्दी - भारत                         ~/Images/Flags/60.gif

1619                 ไทย - ประเทศไทย                               ~/Images/Flags/222.gif

1622                 中文 (简体) - 中国                         ~/Images/Flags/27.gif

1623                 中文 (繁體) - 中國                         ~/Images/Flags/27.gif

1617                 日本語 - 日本                              ~/Images/Flags/143.gif

No rows affected.

(13 row(s) returned)

@RETURN_VALUE = 0

Finished running [dbo].[usp_UserLanguages].

2^nd SQL Query

SELECT (LanguageDetail.LanguageDetailDescriptionIntl + ' - ' + Country.CountryShortNameIntl) AS LanguageAvailableDescriptionIntl 

FROM LanguagesAvailable, LanguageDetail, Country, CountryFlag, LanguageCode, CountryCode 

WHERE LanguageCode.LanguageCodeID = LanguagesAvailable.ViewLanguageCodeID 

AND CountryCode.CountryCodeID = LanguagesAvailable.ViewCountryCodeID 

AND LanguagesAvailable.LanguageDetailID = LanguageDetail.LanguageDetailID 

AND LanguagesAvailable.CountryID = Country.CountryID 

AND Country.CountryFlagID = CountryFlag.CountryFlagID 

AND (LanguageDetail.LanguageDetailDescriptionEng + ' - ' + Country.CountryShortNameEng) IN 
(
	--this inner query will return the english name of the language that the user has saved to the language version table (English - US).

	SELECT (LanguageDetail.LanguageDetailDescriptionEng + ' - ' + Country.CountryShortNameEng) 

	FROM LanguageDetail, Country, LanguagesAvailable, LanguageVersion

	WHERE LanguagesAvailable.LanguageDetailID = LanguageDetail.LanguageDetailID 

	AND LanguagesAvailable.CountryID = Country.CountryID 

	AND LanguagesAvailable.LanguageAvailableID = LanguageVersion.LanguageAvailableID 

	AND LanguageVersion.UserID = @UserID 
)

AND (RTRIM(LanguageCode.LanguageCode) + '-' + RTRIM(CountryCode.CountryCode)) = 
(
	--this inner query will return the current language code (el-GR) that the user is viewing the site in. 

	SELECT (RTRIM(LanguageCode.LanguageCode) + '-' + RTRIM(CountryCode.CountryCode)) 

	FROM LanguagesAvailable, LanguageVersion, LanguageView, LanguageCode, CountryCode 

	WHERE LanguageCode.LanguageCodeID = LanguagesAvailable.TranslationLanguageCodeID 

	AND CountryCode.CountryCodeID = LanguagesAvailable.TranslationCountryCodeID 

	AND LanguagesAvailable.LanguageAvailableID = LanguageVersion.LanguageAvailableID 

	AND LanguageVersion.LanguageVersionID = LanguageView.LanguageVersionID 

	AND LanguageView.UserID = @UserID 
)

ORDER BY LanguageAvailableDescriptionIntl ASC

2^nd Query Output 

LanguageAvailableDescriptionIntl

--------------------------------

Αγγλικά (ΗΠΑ) – Αυστραλία

Γαλλικά – Γαλλία

Γερμανικά – Γερμανία

Εβραϊκά – Ισραήλ

Ελληνικά – Ελλάδα

Ιαπωνικά – Ιαπωνία

Ισπανικά – Ισπανία

Κινέζικα (απλοποιημένα) – Κίνα

Κινέζικα (Παραδοσιακά) – Κίνα

Περσικά – Ιράν

Πολωνικά – Πολωνία

Ταϊλανδικά – Ταϊλάνδη

Χίντι – Ινδία

No rows affected.

(13 row(s) returned)

@RETURN_VALUE = 0

Finished running [dbo].[_RETURNS_6_DIFFERENT_INTERNATIONAL_DESCRIPTIONS].

Can use a temporary table @temptbl and insert the values returned from the 1st query and then use inner join on @temptbl and 2nd query you ll get the desired output.

Hope this helps.