mySQL error: #1248 – Every derived table must have its own alias

by

Well, as the error says, you have to name every derived table. For instance

(SELECT   
    member_id,
    email
FROM exp_members
WHERE member_id = exp_channel_titles.author_id)

Is a derived table. Add a name like so:

(SELECT   
    member_id,
    email
FROM exp_members
WHERE member_id = exp_channel_titles.author_id) tempTableNameGoesHere

(I think I’m sure there is no need for an as between the bracket and the name, but I suppose you can try it, or look it up from here 😉 )

Your follow-up question (how long are we going to do this? 🙂 )

 WHERE title LIKE %Member%

should be

WHERE title LIKE '%Member%'

More Related Contents:

  1. Are table names in MySQL case sensitive?
  2. MySQL: is a SELECT statement case sensitive?
  3. Check overlap of date ranges in MySQL
  4. 1114 (HY000): The table is full
  5. UPDATE multiple tables in MySQL using LEFT JOIN
  6. How to raise an error within a MySQL function
  7. What is maximum query size for mysql?
  8. Finding all parents in mysql table with single query (Recursive Query)
  9. How do I retrieve my MySQL username and password?
  10. How to execute a MySQL command from a shell script?
  11. Select most common value from a field in MySQL
  12. MySQL update a joined table
  13. Returning the ‘last’ row of each ‘group by’ in MySQL
  14. Optimal MySQL settings for queries that deliver large amounts of data?
  15. mysql configuration stops at “starting server”
  16. How does a MYSQL Self-Join Work?
  17. How to change the default port of mysql from 3306 to 3360
  18. Is it possible to reference one column as multiple foreign keys?
  19. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
  20. How to Import Multiple csv files into a MySQL Database
  21. MySQL error #2014 – Commands out of sync; you can’t run this command now
  22. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  23. Row to column transformation in MySQL
  24. Data truncated for column?
  25. How to reuse auto_increment values? [duplicate]
  26. MySQL search json value by key in array
  27. How to import large sql file in phpmyadmin
  28. How to figure out size of Indexes in MySQL
  29. #1060 – Duplicate column name ‘id’
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment