如何从2个表中选择VB.NET [英] How to select from 2 tables VB.NET
问题描述
嗨所以我用下表得到了这个数据库
表1：
Hi so i got this database with the following tables
TABLE 1:
--------------------------------------
|REF|ID_RECIEVED|ID_DATE|POA|POA_DATE|
|-------------------------------------
|001|YES | |YES| |
|002|YES | |NO | |
-------------------------------------- < br $>
表2：
TABLE 2:
------------------------------
|REF|CRED_NAME|COB|ACCEPTANCE|
------------------------------
|001|AFRICAN |YES|YES |
|001|NEDBANK |YES|YES |
|002|NEDBANK |YES|YES |
------------------------------
所以基本上从表1开始，只有一个Ref，但是表2可以有重复
我想要做的是，我想显示所有Refs Where（表1） ）ID_RECIEVED，POA和FROM（表2）COB，接受是肯定的
我正在使用带有ms访问数据库的vb.net并且不知道从哪里开始< br $> b $ b
我尝试了什么：
不知道怎么办，但是任何帮助都是有用的
So basically from table 1, there can only be one Ref but table 2 can have duplicates
What i want to do is, i want to display all Refs Where(TABLE 1) ID_RECIEVED,POA and FROM (TABLE 2) COB,ACCEPTANCE is yes
I am using vb.net with a ms access database and got no idea where to start
What I have tried:
Not sure how to do it, but any help would be usefull
推荐答案
目前还不清楚你的外键是什么。对我来说，它看起来像REF专栏，所以我会按照这个假设。
你在VB代码中使用的SQL查询将是
It isn't clear what your foreign key is. To me it looks like REF column so i'll go with that assumption.
Your SQL query to use in your VB code would be
SELECT * FROM Table1 AS A
JOIN Table2 AS B ON B.REF = A.REF
WHERE A.ID_RECEIVED = 'YES' AND A.POA = 'YES' AND B.COB = 'YES' AND B.ACCEPTANCE = 'YES'
在.net中执行sql。
如何：创建并执行返回行的SQL语句 [ ^ ]
如果你需要VB中的更多帮助，一个简单的谷歌搜索将返回大量链接，为你提供大量的例子。
Executing sql in .net.
How to: Create and Execute an SQL Statement that Returns Rows[^]
If you need more help with that in VB, a simple google search will return plenty of links that will provide you tons of examples.
尝试：
Try:
SELECT b.REF, a.ID_RECIEVED, a.ID_DATE, A.POA, A.POA_DATE b.CRED_NAME FROM Table2 b
JOIN Table1 a ON a.REF = b.REF
WHERE b.COB='YES' AND b.ACCEPTANCE='YES'
这篇关于如何从2个表中选择VB.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
