Need Help Writing Simple Query

[Mark Phillips]

I have been away from sql for awhile, and can't seem to figure out how to
write a simple query for two tables.

Table 1 has many columns, two of which are hID and vID. Table 2 has two
columns, ID and name. The hID and vID in table 1 correspond to the IDs in
table 2. I want to make a query so I get all the columns from table 1, but
substitute the names from table 2 for the hID and vID values. For example,

Table 1:
col 1, col 2, hID, vID, col 3
A        B        1     2     C

Table 2:
ID, name
1    fred
2    sam

Query result:
col1, col 2, hName, vName, col 3
A       B        fred      sam       C

Thanks!

Mark