To do this, you must tell $[officename] what the relationship exists between the data in the two spreadsheets. To do this, click a field name in a table (for example, the field name &quot; Item-Number &quot; from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table ( &quot; Item-Number &quot; from the Item table). When you release the mouse button, a line connecting the two fields in the two windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query.
为此，单击一个表格中的一个字段名称（例如客户表中的 &quot; Item-Number &quot; 字段），并按住鼠标键把它拖到另一个表格的字段名称上（ &quot; Item &quot; 表格的 &quot; Item-Number &quot; ）。当松开鼠标键，您会看到一根线条已把两个窗口中的这两个字段连接起来了。在由此产生的 SQL 查询中将登记相应的条件，即这两个数据字段的内容必须相同。