Using the CONNECT statement is optional for some DBMSs. However, if it is not specified, the default values for all of the database connection arguments are used. Any return code or message that is ...

In this sample statement, the condition (table1.keyfield=table2.keyfield) tells SQL to find records in both tables that contain matching values in the column named by keyfield.

Using default values on database columns helps to insulate database design issues from application code. Find out how to change a column's default value at a later date using a single command.