Fixed!!
The inner joins were working just fine, it was the display part that wasn't.
Got that fixed as well, and all is good.
The answer (for future help reasons...)
All it needs to know is the name of the recordset and the fields name.
So, for example, to display diety_name from your recordset WADAtoon, in the table from your example page, you need to do the following..
1. ensure diety_name is declared as an output field in your select statement
2. add the data to the (existing) repeated table.
If you wanted the column Diety Name in your table, immediately after Name: for example
On your page, you have a table tag, which looks something like
<table class="WADAResultsTable" border="0" cellpadding="0" cellspacing="0">
which contains the field headers.
<th class="WADAResultsTableHeader">Name:</th>
<th class="WADAResultsTableHeader">Class:</th>
<th class="WADAResultsTableHeader">Level:</th>
etc
Firstly, add a new tag like so
<th class="WADAResultsTableHeader">Name:</th>
<th class="WADAResultsTableHeader">Diety Name:</th>
<th class="WADAResultsTableHeader">Class:</th>
<th class="WADAResultsTableHeader">Level:</th>
Then, further down, you add a new row to the repeat region of the table, (within the do loop)
<td class="WADAResultsTableCell"><?php echo($row_WADAtoon['Toon_name']); ?></a></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAtoon['diety_name']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAtoon['Toon_class']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAtoon['Toon_level']); ?></td>
(Make sure your field names are spelled correctly, and remember the code is case specific, so don't forget capital etters where appropriate.)
