如何在ms访问中从不同表的相同列获取数据 [英] How to get data from same columns of different table in ms access

问题描述

我有表SCHEMETRN1和SCHEMETRN2，它们有SCHEME_ID和SCHEME_YEAR作为公共列。

我想从这两个表中获取数据。可以帮助我吗？

I have table SCHEMETRN1 and SCHEMETRN2 which have SCHEME_ID and SCHEME_YEAR as common columns.
I want to get data from both these tables.Can any1 help me?

推荐答案

我真的不明白你的意思。但是你可以尝试联合它。

I don't really get what you mean. But you can try to union it.

SELECT SCHEME_ID, SCHEME_YEAR
FROM  SCHEMETRN1

UNION

SELECT SCHEME_ID, SCHEME_YEAR
FROM  SCHEMETRN2

OR

SELECT *
FROM SCHEMETRN1
INNER JOIN SCHEMETRN2 ON SCHEMETRN2.SCHEME_ID = SCHEMETRN1.SCHEME_ID
    AND SCHEMETRN2.SCHEME_YEAR= SCHEMETRN1.SCHEME_YEAR

这篇关于如何在ms访问中从不同表的相同列获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！