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>|,
  |<SPAN STYLE='color: #FF0000'>owner</SPAN>|,
           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>