references the lCategoryID primary key in the same table<BR>szCategoryName varchar(100)<BR><BR>So for example you could have something like this to desribe the relationship: Electronics ...

One reason is that it's riskier because the SQL statements aren't parsed until runtime, so it's more difficult to catch simple ... in the first example actually generates a recursive SQL statement ...