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