• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

19. Some Common Data Manipulation Problems > 19.9. A Matching Problem

A Matching Problem

Table 19-17 presents programmers and their language skills. Table 19-18 specifies the language requirements for a number of different jobs. We want to display a list of the jobs and their respective qualified programmers.

Table 19-17. Programmers table: Programmers and their language skills

Name

Language

Blaise Pascal

VB

Blaise Pascal

C++

Blaise Pascal

Access

Blaise Pascal

Excel

Gauss

VB

Gauss

Access

Gauss

Delphi

Gauss

SQL Server

Smith

C++

Von Neuman

VB

Von Neuman

C++

Wordsworth

Delphi

Wordsworth

C++

Wordsworth

Word

Table 19-18. ProgrammingJobs table

JobID

Language

1

VB

1

Access

2

C++

3

C++

3

SQL Server

4

Delphi

5

VB

5

Pascal

Solution

One solution is given by the following SQL statement:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint