即使资料表在资料库中不具有自反关联性,也可以将资料表联结至它本身。
You can join a table to itself even if the table does not have a reflexive relationship in the database.
使用这种自反关联性便可将资料表联结到该资料表本身,您可以建立结果集,其中每个资料列都包含某位上司的名称和该上司旗下其中一名员工的名称。
By joining the table to itself using this reflexive relationship, you can establish a result set in which each row contains a boss's name and the name of one of that boss's employees.
应用推荐