SQL多條件查詢語句Select

SQL多條件查詢語句
1.sql2 = "select *from Info where BarCode ='" & BarCode.Text & "' "
2.sql3 = "select *from Info where AnalysisID='' "
怎樣把以上2條SQL合并起來；
Set rs = TransactSQL(sql2 & sql3)

---

sql2 = "select *from Info where BarCode ='" & BarCode.Text & "' and  AnalysisID=''"

---

有答案了，飘走~~

---

引用

sql2 = "select *from Info where BarCode ='" & BarCode.Text & "' and  AnalysisID=''"

綠色字體是表示空格的意思嗎？

---

不含字符的空字符串''
---------------------
含一个空格的字符串' '