sql
No notes
Syntax:
MySQL
51&q=SELECT&lr=lang_en">SELECT a.name, c.movieid 51&q=FROM&lr=lang_en">FROM actor 51&q=AS&lr=lang_en">AS a, casting 51&q=AS&lr=lang_en">AS c 51&q=WHERE&lr=lang_en">WHERE a.actorid = c.actorid 5.1/en/non-typed-operators.html">and c.movieid = (51&q=SELECT&lr=lang_en">select movieid 51&q=FROM&lr=lang_en">from casting 51&q=WHERE&lr=lang_en">where actorid = (51&q=SELECT&lr=lang_en">select actorid 51&q=FROM&lr=lang_en">from actor 51&q=WHERE&lr=lang_en">where name = "kevin bacon"));