Export (0) Print
Expand All
Expand Minimize

Specify Join Filter

SQL Server 2000

Enter only the conditions to be used in the filter. The  SELECT*FROM . . . ON statement has already been supplied and cannot be modified. For example, enter only:

CUSTOMER.CUST_ID = ORDERS.CUST_ID

Any column names that are identical in both tables and, therefore, could resolve to either table, should be qualified with the name of the table.

See Also

Join Filters

Show:
© 2014 Microsoft