![A social media post by Santa Claus @Santaclaus@c.im. It says: A valiant effort has been made by Little Tim this year, who for some reason has decided to change his name to Tim); INSERT INTO [NiceList] SELECT * FROM [NaughtyList];- HO HO HO! Nice try Tim. I don't use #SQL, I use several dozen interconnected #Excel spreadsheets, like a professional.](https://programming.dev/pictrs/image/99f69aed-4aaf-473c-ad24-2523041b7bd5.png)
I would make two separate views.
CREATE VIEW NiceList AS
SELECT * FROM Children
WHERE behavior = 'nice'
AND parent.income > 40000;
CREATE VIEW NaughtyList AS
SELECT * FROM Children
WHERE behavior = 'naughty';
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
replies: