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`

You should add what kind of problems. Although in this case, I'm fairly sure it's the numeric table aliases. Try t1 instead of 1 — Pekka
– Pekka, Commented Mar 27, 2011 at 8:39
I am still getting an error which says "#1046 - No database selected". Thank you for your help. — user678502
– user678502, Commented Mar 27, 2011 at 16:43

Snowbear · Accepted Answer · 2011-03-27 08:40:49Z

2

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

answered Mar 27, 2011 at 8:40

Snowbear

17.3k3 gold badges45 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user678502 Over a year ago

I am still getting an error which says "#1046 - No database selected". Thank you for your help.

Pekka Over a year ago

@user you need to choose a database in phpMyAdmin before you can run the query. There should be a list on the left hand side

user678502 Over a year ago

Hi, I am now getting this error #1146 - Table 'classicmodels2.classicmodels1' doesn't exist with this query SELECT t2.payments.checkNumber,t1.customers.customerName FROM classicmodels1 AS t1, classicmodels2 AS t2 WHERE t1.customers.customerName=t2.payments.checkNumber

Snowbear Over a year ago

@user, you should read something about SQL. t2.payments.checkNumber - this is invalid construction.

Collectives™ on Stack Overflow

problem with query for phpmyadmin

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related