C#中的数据库查询

问题描述

我想从3个表中检索数据并使用c#和Access数据库插入一个表中，这可能吗?所有表都有一个逗号字段，可用于链接4个表.您能建议我一些实现此目标的方法吗?

I want to retrieve data from 3 tables & insert into one table using c# & Access database, is it possible? All tables have one comman field which can be used to link 4 tables. Can you suggest me some way to achieve this?

推荐答案

select  A.a,B.B, C.c
        into [NEW_TABLE]
        from A
        inner join B on A.id = B.Aid
        inner join C on B.id = C.Bid

insert into Table4 select t1.ColumnName,t2.ColumnName,t3.ColumnName from Table1 t1,Table t2,Table t3
where t1.ColumnName = t2.ColumnName and t1.ColumnName = t3.ColumnName

这篇关于C#中的数据库查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！