试试这个:
SELECT t1.date1 AS date, t1.name1 AS name, t1.num1 AS num
FROM t1 INNER JOIN
t2 ON t1.date1 = t2.date2
UNION
SELECT t2.date2 AS date, t2.name2 AS name, t2.num2 AS num
FROM t1 INNER JOIN
t2 ON t1.date1 = t2.date2
有问题:
用了txlicenhe(不做技术高手) 的建议后:
Error in SELECT clause: expression near '+'.
Missing FROM clause.
Error in SELECT clause: expression near ','.
Error in SELECT clause: expression near 'FROM'.