This is an example of how to SELECT
using "INNER JOIN"

The boxes on this page are draggable

 <<<<<<<<<<<
 The SQL used on this page
    SELECT  SELECT name |<SPAN STYLE='color: #FFFFFF; background: #0000FF; margin: 4px; padding: 2px;'>name</SPAN>|,
           instinct,
           family,
           height,
           owner.name |<SPAN STYLE='color: #FF0000'>owner</SPAN>|,
           color.name |color|,
           club.name |club|,
           club.address |club address|
      FROM dog
     WHERE instinct NOT isin 'hunting,swimming,attacking'
  INNER JOIN owner ON owner = owner.id
  INNER JOIN color ON color = color.code
  INNER JOIN club  ON owner.club = club.id
  ORDER BY instinct
    FORMAT table
      DIV box1

Remember to include the table files used in the SQL:
<SCRIPT TYPE="text/javascript" SRC="data/db/dog.js"></SCRIPT>
<SCRIPT TYPE="text/javascript" SRC="data/db/owner.js"></SCRIPT>
<SCRIPT TYPE="text/javascript" SRC="data/db/club.js"></SCRIPT>
<SCRIPT TYPE="text/javascript" SRC="data/db/color.js"></SCRIPT>