[Wolves] MySQL - equi-join DISTINCT

Philip Harper ph004h7245 at blueyonder.co.uk
Wed Jul 18 12:36:10 BST 2007


$last = mysql_query("SELECT DISTINCT * FROM user, userlog WHERE 
userlog.username = user.username LIMIT 0, 20") or die(mysql_error());

This SQL works, but still returns 4 records, the total number of records 
in the table userlog, so the DISTINCT clause isn't filtering out the 
duplicates in table userlog, anyone any ideas where DISTINCT goes in the 
join?




More information about the Wolves mailing list