错了
是
(
SELECT '' AS Code,type as Type
FROM test1
WHERE 1
)
UNION ALL (SELECT code AS Code,'' as Type
FROM test2
WHERE 1
)
是
(
SELECT '' AS Code,type as Type
FROM test1
WHERE 1
)
UNION ALL (SELECT code AS Code,'' as Type
FROM test2
WHERE 1
)
SELECT '' AS Code
FROM test1
WHERE 1
)
UNION ALL (SELECT code AS Code
FROM test2
WHERE 1
)
类型转化函数你可以使用CAST()函数。如:
...where mydate>cast('2000-01-01' as date) ...