Databases Reference
In-Depth Information
8.
The
product_id
field is a key field in the
products
table and a foreign key
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