3 ms·
> Retrieving both employee and customer meal items When you're getting two separate sets of things in one query you should expect to use union. This isn't so m
by gfody 6y ago
> Retrieving both employee and customer meal items
When you're getting two separate sets of things in one query you should expect to use union. This isn't so much a performance optimization as just expressing the query properly.
Imagine starting with just this weird SQL that gets both employee and customer meal items using only joins, and then trying to infer the original intent.