-
-
Notifications
You must be signed in to change notification settings - Fork 109
Closed
Labels
Description
As I was researching http://stackoverflow.com/questions/39374782/sql-query-with-limit-doesnt-work-in-phpmyadmin, I discovered that the 'natural' keyword is not recognized as part of a JOIN query:
SELECT * FROM `myTable`
natural JOIN `column1`
natural JOIN `column2`
WHERE `mytable`.`something` = 1
ORDER BY mytable_date DESC LIMIT 0,4
Or, more simply (and actually tested on 'sakila' from the CLI client):
select * from actor natural join actor_info;