[thelist] SQL: Help with a simple join

[Casey Crookston]

Two tables in question: tb_employees and tb_titles.

tb_employees:

+-----------------+-------------+-----------+
|     first_name       |    last_name  |   title_id     |
+-----------------+-------------+-----------+

tb_titles:

+------------+-------+
|     title_id     |    title   |
+------------+-------+

I now need to dispaly the first names, last names, and titles.  Help me out
a little with the SQL syntax:

SELECT first_name.a, last_name.a, title.b, FROM tb_employees.a, tb_titles.b
WHERE title_id.a = title_id.b ORDER BY last_name

Here's the error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a
reserved word or an argument name that is misspelled or missing, or the
punctuation is incorrect.
/boser/about/ind.asp, line 9

Thanks!!!

Casey