when I run this query
SELECT TT10000000001991666187.crcid, TT10000000001991666187.sum,
TT20000000001991666187.sum, names.item
FROM TT10000000001991666187 USE INDEX(PRIMARY)
INNER JOIN names USE INDEX(PRIMARY)
ON (TT10000000001991666187.crcid = names.crcid and names.type = 29)
LEFT JOIN TT20000000001991666187 USE INDEX(PRIMARY)
on (TT10000000001991666187.crcid = TT20000000001991666187.crcid)
ORDER BY TT10000000001991666187.sum DESC;
I get
+------------+-----+------+-------------------------------------------------
-------------------------------------+
| crcid | sum | sum | item
|
+------------+-----+------+-------------------------------------------------
-------------------------------------+
| 1893454487 | 1 | NULL | mozilla/4.76 [en] (x11; u; linux 2.4.2 i586)
|
| 1412536101 | 1 | NULL | mozilla/4.0 (compatible; msie 5.5; aol 6.0;
windows 98; vnie5) |
| 2725724903 | 1 | NULL | mozilla/4.0 (compatible; msie 5.0; windows 98;
digext; computer telephony solutions) |
| 3304808295 | 1 | NULL | mozilla/4.0 (compatible; msie 5.5; windows nt
5.0; alisys_inicia) |
| 1323923799 | 1 | NULL | mozilla/4.0 (compatible; msie 5.01; windows nt;
tucows network; netcaptor 6.2.1a) |
+------------+-----+------+-------------------------------------------------
-------------------------------------+
which is exactly what I expect
However when I run the same query with an insert into
the Item field is blank
INSERT INTO TT30000000001991666187 SELECT TT10000000001991666187.crcid,
TT10000000001991666187.sum, TT20000000001991666187.sum, names.item
FROM TT10000000001991666187 USE INDEX(PRIMARY)
INNER JOIN names USE INDEX(PRIMARY)
ON (TT10000000001991666187.crcid = names.crcid and names.type = 29)
LEFT JOIN TT20000000001991666187 USE INDEX(PRIMARY)
on (TT10000000001991666187.crcid = TT20000000001991666187.crcid)
ORDER BY TT10000000001991666187.sum DESC;
select * from TT30000000001991666187;
+------------+-----+----+------+
| crcid | sum | LP | item |
+------------+-----+----+------+
| 1893454487 | 1 | 0 | |
| 1412536101 | 1 | 0 | |
| 2725724903 | 1 | 0 | |
| 3304808295 | 1 | 0 | |
| 1323923799 | 1 | 0 | |
+------------+-----+----+------+
does anyone know why this is and how I can fix this problem.
I am running 3.23.34 on Windows 2000
Roger Karnouk
---------------------------------------------------------------------
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
