OLE DB Programmer's Reference |
Consider CROSSJOIN(S1, S2). This can be expanded as follows:
The following query performs the CROSSJOIN operation:
SELECT S1.*\Rank, S2.*\Rank, Newrank AS Rank FROM (SELECT S1.*\Rank, S2.*\Rank FROM S1, S2) RANK ROWS AS NewRank RANKORDER BY Rank1, Rank2
The notation "S1.*\Rank" means "[All] columns of S1, minus the Rank column."
1998-2001 Microsoft Corporation. All rights reserved.