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
mysql> SELECT * from boxrec.shows USE INDEX (date)
-> , boxrec.schedule USE INDEX (show_id)
-> where
-> boxrec.schedule.show_id = boxrec.shows.show_id and
-> shows.date >= '2002-06-08'
-> ;
+---------+------------+---------+--------+----------------+---------------+
----------+-------------------------------+---------+------------+----------
--+------------------+----------------+-----------------------------------+-
-----+--------------------+---------+----+
| show_id | date | country | region | towncity | venue |
location | tv | bout_id | boxer_a_id | boxer_b_id
| rounds_scheduled | time_stamp | comment |
user | division | show_id | tv |
+---------+------------+---------+--------+----------------+---------------+
----------+-------------------------------+---------+------------+----------
--+------------------+----------------+-----------------------------------+-
-----+--------------------+---------+----+
| 212405 | 2002-09-05 | EN | London | Bethnall Green | York Hall |
| ESPN2,HBO,HBOPPV,SHOWTIME,SKY | 2 | 025713 | 005785 |
12 | 20020704185424 | | John | Heavyweight
| 212405 | 0 |
| 212405 | 2002-09-05 | EN | London | Bethnall Green | York Hall |
| ESPN2,HBO,HBOPPV,SHOWTIME,SKY | 3 | 006685 | 115515 |
8 | 20020704185941 | this is a test | John | Light
Welterweight | 212405 | 0 |
| 212405 | 2002-09-05 | EN | London | Bethnall Green | York Hall |
| ESPN2,HBO,HBOPPV,SHOWTIME,SKY | 4 | 050128 | 000000 |
10 | 20020704191452 | | John |
Middleweight | 212405 | 0 |
| 212405 | 2002-09-05 | EN | London | Bethnall Green | York Hall |
| ESPN2,HBO,HBOPPV,SHOWTIME,SKY | 5 | 004601 | 000000 |
4 | 20020704191728 | | John |
Featherweight | 212405 | 0 |
| 212406 | 2002-07-06 | JP | Tokyo | | Korakuen Hall |
| | 6 | 014700 | 076527 |
12 | 20020704192405 | Japanese super bantamweight title | John | Super
Bantamweight | 212406 | 0 |
| 212406 | 2002-07-06 | JP | Tokyo | | Korakuen Hall |
| | 7 | 019202 | 028943 |
0 | 20020704192451 | | John |
Featherweight | 212406 | 0 |
| 212406 | 2002-07-06 | JP | Tokyo | | Korakuen Hall |
| | 8 | 120002 | 120003 |
0 | 20020704192518 | | John |
| 212406 | 0 |
+---------+------------+---------+--------+----------------+---------------+
----------+-------------------------------+---------+------------+----------
--+------------------+----------------+-----------------------------------+-
-----+--------------------+---------+----+
7 rows in set (0.00 sec)
mysql>
---------------------------------------------------------------------
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]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
