Contact: aviboots(AT)netvision.net.il
43,976 questions
57,432 answers
573 users
-- SELECT with DISTINCT by default SELECT FirstName FROM Workers UNION SELECT Meal FROM LunchOrders
SELECT FirstName FROM Workers UNION SELECT Meal FROM LunchOrders ORDER BY Meal
-- (UNION ALL) SELECT without DISTINCT, allow duplicate SELECT FirstName FROM Workers UNION ALL SELECT Meal FROM LunchOrders
SELECT category FROM all_info UNION SELECT word FROM words WHERE word LIKE '%a%'
SELECT category FROM all_info UNION SELECT word FROM words WHERE word LIKE '%ie%' Order BY category