Re: SET problem (bug ?) on JOIN

2002-07-08 Thread JohnShep
sql,query No worries, problem solved. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]>

SET problem (bug ?) on JOIN

2002-07-08 Thread JohnShep
Can anyone shed any light as to why in the following query the "tv" field shows up twice in the returned set ? The first occurance is correct, the second spurious one at the end is empty and is unfortunately the one my code picks up. The tv field occurs only in the shows table. Thanks, John mysq