problem with query for phpmyadmin

Question

I am new to sql/phpmyadmin and am having problems with this query.

SELECT `2.checkNumber`,`1.customerName'
FROM 
`classicmodels1` AS 1,
`classicmodels2` AS 2
WHERE `1.customerNumber`=`2.customerNumber`

Answer 1

Replace:

`1.customerName'

with

`1.customerName`

Or even better rewrite it to avoid using quotes. Also I would replace aliases '1' and '2' with 't1' and 't2' respectively:

SELECT t2.checkNumber,t1.customerName
FROM 
classicmodels1 AS t1,
classicmodels2 AS t2
WHERE t1.customerNumber=t2.customerNumber