MySQL error 1248, Creating proper query. Beginner Q

Question

I am running into some difficulty with the following query.

SELECT maker, speed 
FROM  
(
    SELECT * 
    FROM product 
    NATURAL JOIN laptop
) 
WHERE hd > 30;

I am trying to find the maker and speed of laptops with hard drives greater than 30 gigabytes.

I have two relations laptops and products. Laptops has the tuples (maker, model, type) and laptop has the tuples (model, speed, ram, hd, screen, and price).

What I think I am doing.

Joining product with laptop with natural join, which I think and does (when submitted by itself) give me a relation of laptop but with two more columns maker and type.
I then am trying to just select maker and speed from that table where the size of the hd is greater than 30.

Are you receiving an error? If so, please show us the error. Are you receiving a resultset other than what you're expecting? If so, please show us. — Bob Kaufman
– Bob Kaufman, Commented Apr 3, 2012 at 19:56
What is the difficulty? Does your query give an error? What database are you using? — Andomar
– Andomar, Commented Apr 3, 2012 at 19:57

Michael Berkowski · Accepted Answer · 2012-04-03 20:03:09Z

3

A subquery in the FROM clause requires a table alias:

SELECT maker, speed 
FROM  
(
    SELECT * 
    FROM product 
    NATURAL JOIN laptop
  /* include an alias with AS */
) AS products_sub
WHERE hd > 30;

From the docs:

A table_subquery is also known as a subquery in the FROM clause. Such subqueries must include an alias to give the subquery result a table name. A trivial example follows; see also Section 12.2.9.8, “Subqueries in the FROM Clause”.

However for your example, the subquery isn't needed at all.

SELECT maker, speed 
FROM products NATURAL JOIN laptop
WHERE hd > 30;

Note that NATURAL JOINs are not usually recommended, and it is best to be explicit about the columns joined in an ON clause.

edited Apr 3, 2012 at 20:03

answered Apr 3, 2012 at 19:57

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

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

2 Comments

Andomar Over a year ago

The subquery serves no puprose and can be omitted

user330315 Over a year ago

+1 for "natural joins are not usually recommended". Very good point.

Ankit Sharma · Accepted Answer · 2012-04-04 06:07:40Z

0

 SELECT maker, speed 
  FROM products   JOIN laptop 
  WHERE hd > 30;

answered Apr 4, 2012 at 6:07

Ankit Sharma

4,0792 gold badges31 silver badges50 bronze badges

Collectives™ on Stack Overflow

MySQL error 1248, Creating proper query. Beginner Q

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related