How to explain a not very complex query to an SQL beginner
Posted on 2011-04-24
Consider the following:
Then we have the query that uses item1_id and item2_id as inputs:
from category_relations cr, item_categories ic1, item_categories ic2
How would you best explain the need for calling item_categories twice to an SQL beginner? Things like this has become pretty second-nature to me, but having to explain it in simple terms suddenly got me stumped. Thanks.