.NET Answers

I received the following question a couple of days ago from a programmer using the “Ask  a Question” form which you can access from the menu of this blog:

Given the following table:

How do I select names of persons who know both Hindi and English?

In this table, that query should return Nikhil and Kisu.

Normally, if it were me, I’d create a Language table and a Name table and use an intermediate table to join them.  But the solution would still be about the same.  So we’ll work with the table we’ve been given.

What we need to do here is make this look like it is two tables–The Hindi table and the English table–and do a JOIN between the two:

SELECT     NameLang.Name
FROM         NameLang INNER JOIN
NameLang AS NameLang_1 ON NameLang.Name = NameLang_1.Name
WHERE     (dbo.NameLang.Language = ‘English’) AND (NameLang_1.Language = ‘Hindi’)

This pulls all of the names from the table where the person speaks English and then JOINS them to a selection of all the names of people who speak Hindi.  What you get back is a list of names of all the people who speak both.

Other Related Items:

Wonder Pets!: Join the CircusWONDER PETS-JOIN THE CIRCUS (DVD)

National Treasure 2 - Book of Secrets (Widescreen)Less engrossing than its 2004 predecessor National Treasure, Jon Turteltaub's busy sequel National Treasure: Book of Secrets is nevertheless a colorfu... Read More >

Join The Marines Poster WWIIJoin The Marines Poster WWII Military Replica Poster. 23" x 35" - Individually Sleeved.

Related Post

• Random in SQL – SQL For Programmers
• SQL WHILE – SQL For Programmers
• Basic SQL Commands – SQL For Programmers
• SQL For Programmers – Stored Procedure Basics
• SQL SELECT CASE Instead of IIF

Bookmark to:

Hide Sites

Comments are closed.