sql查询问题 - .NET技术 / ASP.NET

SELECT So_Master.sales, wf_status.Result, So_Master.so_no, So_Master.customer_name, 
  So_Master.pi_no
from So_Master INNER JOIN
  wf_status ON So_Master.so_no = wf_status.doc_no
WHERE (So_Master.so_no = N'SCN091000304') OR
  (So_Master.pi_no = N'V091000274') AND (So_Master.Result = N'Result'),各位老大,SQL查询怎么弄,我想有一个(so_no or pi_no) 并and result,这样的查询怎么弄.高手指点了

---

直接加括号不行..

---

SQL code:

SELECT So_Master.sales, wf_status.Result, So_Master.so_no, So_Master.customer_name,
So_Master.pi_no
from So_Master INNER JOIN
wf_status ON So_Master.so_no = wf_status.doc_no
WHERE (So_Master.so_no = N'SCN091000304' OR
So_Master.pi_no = N'V091000274') AND So_Master.Result = N'Result'

---

adasdasdasd

---

SQL code:
WHERE (So_Master.so_no = N'SCN091000304' OR
So_Master.pi_no = N'V091000274') AND (So_Master.Result = N'Result')

---

SQL code:
WHERE (So_Master.so_no = N'SCN091000304' AND (So_Master.Result = N'Result') OR
(So_Master.pi_no = N'V091000274' AND So_Master.Result = N'Result')

---

要不,你写成(A&a