mysql - 如何在一个查询中从两个表中检索数据

Question

关闭。此题需要 details or clarity 。目前不接受答案。

---

想要改进这个问题吗？通过 editing this post 添加详细信息并澄清问题.

已关闭 9 年前。

Improve this question

Try
  With com
    .Connection = con
    .CommandText = "SELECT * FROM attendance WHERE id_no='" & ComboBox1.SelectedValue & "'AND date BETWEEN '" & startDate.Text & "' AND '" & endDate.Text & "';"

  End With

  Catch ex As Exception
     MsgBox(ex.Message)

我正在尝试从我的工资单和出勤表中获取数据

Answer 1

尝试这样

"SELECT A.*,P.* 
FROM Attendance A JOIN payroll P ON A.id_no = P.id_no
WHERE A. id_no='" & ComboBox1.SelectedValue & "'AND 
A.date BETWEEN '" & startDate.Text & "' AND '" & endDate.Text & "';"