=?UTF-8?Q?Grega_Leskov=C5=A1ek?= [MYSQL] INTERSECT, MINUS
Oct 16, 2011; 13:42
=?UTF-8?Q?Grega_Leskov=C5=A1ek?=
[MYSQL] INTERSECT, MINUS
WHat is wring with the following three sentences?
SELECT p.name, p.gender, e.pizza FROM Person p, Eats e WHERE p.name e.name AND p.gender = 'female' AND (e.pizza = 'mushroom') INTERSECT SELECT p.name, p.gender, e.pizza FROM Person p, Eats e WHERE p.name e.name AND p.gender = 'female' AND (e.pizza = 'pepperoni');
SELECT * FROM Person MINUS SELECT * FROM Person WHERE name='Amy';
mysql> SELECT name FROM Person MINUS SELECT name FROM Person WHERE Person.age < 18;
I've tried my first time sets and am not sure where is the problem, I've tried to google but when translating to my db it just doesn't work, You can download the create db sql here: http://s3.amazonaws.com/dbclass-resources/docs/pizza.sql
=E2=99=A5=E2=99=A5=E2=99=A5 When the sun rises I receive and when it sets I forgive! =E2=99=A5=E2=99=A5=E2=99=A5 =CB=9C=E2=99=A5 -> http://moj.skavt.net/gleskovs/ <- =E2=99=A5 Always, Grega Leskov=C5=A1ek
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Oct 16
Suresh Kuna Re: [MYSQL] INTERSECT, MINUS
Oct 16, 2011; 17:36
Suresh Kuna
Re: [MYSQL] INTERSECT, MINUS
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!