Is it possible to write a SQL query to return specific rows, but then join some columns of those row
- by Rob
I'm having trouble wrapping my head around how to write this query.
A hypothetical problem that is that same as the one I'm trying to solve:
Say I have a table of apples. Each apple has numerous attributes, such as color_id, variety_id and the orchard_id they were picked from.
The color_id, variety_id, and orchard_id all refer to their…