X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?a=blobdiff_plain;f=yarrg%2Fweb%2Froutetrade;h=c62ca60b7f89a7956008cacc7c8998ae944a72c7;hb=3276ebe915a34abf34cf9639e83c85b8adac5245;hp=03ef3e1e8dc4ab99bfc8b29cfc8b69750268845c;hpb=1a23128c88e708c60a40a7248539bb7f29a16190;p=ypp-sc-tools.db-test.git

diff --git a/yarrg/web/routetrade b/yarrg/web/routetrade
index 03ef3e1..c62ca60 100644
--- a/yarrg/web/routetrade
+++ b/yarrg/web/routetrade
@@ -1010,12 +1010,12 @@ END
 <%perl>
 	my $sth_i= $dbh->prepare(<<END);
 		SELECT archipelago, islandid, islandname, timestamp
-			FROM uploads NATURAL JOIN islands
+			FROM uploads JOIN islands USING (islandid)
 			WHERE islandid = ?
 END
 	my $sth_a= $dbh->prepare(<<END);
 		SELECT archipelago, islandid, islandname, timestamp
-			FROM uploads NATURAL JOIN islands
+			FROM uploads JOIN islands USING (islandid)
 			WHERE archipelago = ?
 			ORDER BY islandname
 END