mysql - 在vb.net数据 GridView 中选择多个表sql - sql &vb.net

Question

我试图在 mysql 中选择多个表，然后将其返回到我的应用程序的 datagridview 。下面的 SQL 查询不起作用。 sql有错吗？我在 mysql 中有两个名为“bruker”和“blodgiver”的表

Dim searchQuery As String = "SELECT bruker INNER JOIN blodgiver WHERE CONCAT(bruker_id, fornavn, etternavn, epost, personnummer) like '%" & valueToSeach & "%'"

Dim command As New MySqlCommand(searchQuery, MysqlConn)
Dim adapter As New MySqlDataAdapter(command)
Dim table As New DataTable()

adapter.Fill(table)

DataGridView1.DataSource = table

Answer 1

您必须提供 on 条款。

SELECT * FROM bruker br INNER JOIN blodgiverbd on bd.<link_column1> = db.<link_column2>  WHERE CONCAT(bruker_id, fornavn, etternavn, epost, personnummer) like '%" & valueToSeach & "%'"