mysql-error-1248

every derived table must have its own alias

i am running this query on mysql SELECT ID FROM (SELECT ID, msisdn FROM (SELECT * FROM TT2)); and it is giving this error: Every derived table must have its own alias. what is wrong ? ...

MySql: Query multiple identical dynamic tables.

I have a database with 500+ tables, each with identical structure, that contain historical data from sensors. I am trying to come up with a query that will locate, for example, all instances where sensor n exceeds x. The problem is that the tables are dynamic, the query must be able to dynamically obtain the list of tables. I can query ...

mySQL update question

Hey all i im getting this error when trying to update a table in my database: Every derived table must have its own alias Here is my mysql query i am trying to update with: UPDATE (SELECT clientinfo.idNumber, clientinfo.theCompName, clientoffers.idNumber, clientoffers.expTimeWaiting, clientoffers.theDateStart, clientoffers.theDate...

MySQL: Query to obtain recipes using all given ingredients.

hi I have the following simplified tables: CREATE TABLE recipe(id int, name varchar(25)); CREATE TABLE ingredient(name varchar(25)); CREATE TABLE uses_ingredient(recipe_id int, name varchar(25)); I want to make a query that returns all id's of recipes that contain both Chicken and Cream. I have tried SELECT recipe_id FROM uses_...

Subquery on a join

I'm trying to do a query to filter on rows from one table and then join the results on another table and then filter out additional rows. Here is the query I've written: SELECT * FROM (SELECT media.id AS id2, media.flagged AS flagged2, media.item_status AS status2 FROM media WHERE flagged2 != 'nsfw' ...

MYSQL ERROR 1248 (42000): Every derived table must have its own alias

I cant for the life of me figure out why this is erroring ...