如何合并具有不同数据类型的两个表 [英] how to union two table with different datatype

问题描述

如何合并具有不同数据类型的两个表

How to union two table with different data-types

推荐答案

这样做:

SELECT 
   table1ColA AS COL1,
   table1ColB AS COL2,
   "" AS COL3,
   "" AS COL4
FROM 
   Table1

UNION

SELECT 
   "" AS COL1,
   "" AS COL2,
   table2ColA AS COL3,
   table2ColB AS COL4
FROM 
   Table2 

使用CAST或CONVERT.另外，如果您共享您的代码，我们可以提供更多帮助.请参见此处. [

Use CAST or CONVERT. Also, if you shared your code we could help more. See here.[^]

这篇关于如何合并具有不同数据类型的两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！