Databases Reference
In-Depth Information
8.
The product_id field is a key field in the products table and a foreign key
( http://en.wikipe dia.org/wiki/Foreign_key ) in the brands table, so
we will link these two fields together. Right-click on the product_id field in
the products table, select Equal, and drop the connector onto the product_id
field in the brands table. Notice that this action changes the text SQL query
below the query designer and adds a where clause.
 
Search WWH ::




Custom Search