[thelist] SQL: Help with a simple join

[Stephen Caudill]

Casey Crookston bespaketh on Wednesday, June 18, 2003 2:34 PM:

> 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

Casey,
  The select statement should be:

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

hth,
Stephen Caudill
http://www.mechavox.com