Hi, it seems that when there is an 'union' in a query it transforms the 'null' to '0'
when the field is a number, and more over, I think the result is wrong...
I am using the 4.0.12 mysql server for Win32 in a Windows NT server.
this is the query...
select id, name from customer
union all
select
Tony Bailey writes:
I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out
how to get the query I
need against the version without the union
[skip]
2)
select count(docs.docid) as score, docs.docdate, docs.docid, docs.docsection,
docs.docsubdir, docs.docmsgid,
