.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:

Freud 2-Piece Adjustable Tongue and Groove Bit Set Router Bit Set 1/2" Shank. Freud #99-036An industry leader for over 50 years, the Freud name equals quality, precision and craftsmanship. Freud router bits feature Freud made TiCo Hi-Density... Read More >

Fable: The Lost ChaptersBased on the best-selling award-winning Xbox title Fable, Fable: The Lost Chapters is now fully optimized for the Windows platform complete with expan... Read More >

Motorola Antenna Cable 6" Male-to-maleJoins two Motorola female cables together

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

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.