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 name, instinct, family, height,
           club.address |club address|
      FROM dog
     WHERE instinct NOT isin 'hunting,swimming,attacking'
  INNER JOIN owner ON owner =
  INNER JOIN color ON color = color.code
  INNER JOIN club  ON =
  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>