|
楼主 |
发表于 2014-5-15 17:19:40
|
显示全部楼层
jishuang 发表于 2014-5-15 17:08
报错的ksql发一下看看
select StorageItemBatch.*,BatchItem.firstStoreDate as firstStoreDate,BatchItem.produceDate as produceDate,BatchItem.validDate as validDate,BatchItem.checkoutAgainDate as checkoutAgainDate,BatchItem.lastCheckDate as lastCheckDate,BatchItem.brand as brand,BatchItem.placeOrigin as placeOrigin,BatchItem.manufacturer as manufacturer,BatchItem.batchDescribe as batchDescribe,BatchItem.itemWeight as itemWeight,BatchItem.produceNo as produceNo,BatchItem.workCenterNo as workCenterNo,BatchItem.routingNo as routingNo,BatchItem.procedureNo as procedureNo,BatchItem.procedureName as procedureName
from StorageItemBatch StorageItemBatch
optional join BatchItem BatchItem on StorageItemBatch.batchNo = BatchItem.batchNo AND StorageItemBatch.itemNo = BatchItem.itemNo |
|