本地系统返回Row，但在服务器返回没​​有行 [英] Local system return Row,but in server return no row

问题描述

选择子串（PHT_MSTR_Labs.LabName_short，13,13）为LabName_short，''为GraphColor，COUNT（PHT_IndentRequest.RequestID）为计数

FROM PHT_IndentRequest内连接PHT_MSTR_Labs ON PHT_MSTR_Labs.LabID = SUBSTRING（ PHT_IndentRequest.RequestID，1,5）

LEFT外连接PHT_SamplingDetails ON PHT_IndentRequest.RequestID = PHT_SamplingDetails.RequestID

LEFT OUTER JOIN PHT_MSTR_Employees ON PHT_SamplingDetails.CollectorID = PHT_MSTR_Employees.EmployeeID

WHERE PHT_IndentRequest.RequestDate< ='2014/07/16'和

（PHT_SamplingDetails.DATE_rejection为null或PHT_SamplingDetails.DATE_rejection =''或

PHT_SamplingDetails.DATE_rejection> ='2014/07/16'）和

PHT_IndentRequest.RequestID不在（从PHT_ReceivedSample中选择RequestID，其中Lab_ReceivedDate< ='2014/07/16'

）分组按PHT_MSTR_Labs.LabName_short

select substring(PHT_MSTR_Labs.LabName_short ,13,13) as LabName_short ,'' as GraphColor,COUNT(PHT_IndentRequest.RequestID )as count
FROM PHT_IndentRequest inner join PHT_MSTR_Labs ON PHT_MSTR_Labs.LabID = SUBSTRING(PHT_IndentRequest.RequestID, 1, 5)
LEFT outer join PHT_SamplingDetails ON PHT_IndentRequest.RequestID = PHT_SamplingDetails.RequestID
LEFT OUTER JOIN PHT_MSTR_Employees ON PHT_SamplingDetails.CollectorID = PHT_MSTR_Employees.EmployeeID
WHERE PHT_IndentRequest.RequestDate <= '2014/07/16' and
( PHT_SamplingDetails.DATE_rejection is null or PHT_SamplingDetails.DATE_rejection =''or
PHT_SamplingDetails.DATE_rejection >= '2014/07/16' ) and
PHT_IndentRequest.RequestID not in (Select RequestID from PHT_ReceivedSample where Lab_ReceivedDate <= '2014/07/16'
) group by PHT_MSTR_Labs.LabName_short

推荐答案

Thnx对于eplay @Ashok Rathod，

但其他quries正在发挥作用。



我认为子查询中的pblm条件

可以将此子查询作为连接表格

Thnx For eplay @Ashok Rathod,
But other quries are working.

I think pblm in subquery condition
Can umake this subquery as join form

这篇关于本地系统返回Row，但在服务器返回没​​有行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！