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,这样的查询怎么弄.高手指点了
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,这样的查询怎么弄.高手指点了
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')
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'
So_Master.pi_no = N'V091000274') AND (So_Master.Result = N'Result')
(So_Master.pi_no = N'V091000274' AND So_Master.Result = N'Result')