3 ms·
you can’t easily identify filters I'm not often SQL wrangling these days, so you are probably more aware than I am on intricacies, but often you can wrap subqu
by contingencies 8y ago
you can’t easily identify filters
I'm not often SQL wrangling these days, so you are probably more aware than I am on intricacies, but often you can wrap subqueries like:
SELECT stuff FROM tables WHERE conditions AND table.field IN (
SELECT othertable.otherfield FROM othertables WHERE more_conditions...)
);
IMHO this reads far more easily and both depth and order of execution are clear. I guess at this point in my career (20 years in) my bias is toward code I can walk away from for years and come back to easily.
Clarity is better than cleverness. - Eric S. Raymond, The Art of Unix Programming (2003)
He's got a point. Quote via http://github.com/globalcitizen/taoup http://github.com/globalcitizen/taoup