问一段Query和一个环境配置有关问题
问一段Query和一个环境配置问题
问题一 :vs2003.net如何配置环境才能括号配对,就是我光标所在的括号自动和与之配对的括号高亮显示。
问题二 :请问哪位知道这段query里的PARENT和FRESH是什么意思
SELECT PARENT.containername,
customer.customername,
customer.description,
FRESH.customerlotnumber,
PARENT.qty,
PARENT.targetdevice,
con.containername as SubLot,
con.qty as SubQty,
con.customerlotnumber as SubCustLot,
con.datecode as SubDateCode,
tap.qtyperreel,
FRESH.containername as FreshLot,
product.customerspecificinfo2 as COO,
con.customerorder,
con.custmotherwo,
pac.packagetypename,
smd.shipmentdestinationname,
dim.dimensionname,
lea.leadcountname,
pac.packagetypename || '-' || dim.dimensionname || '-' ||
lea.leadcountname as PDL,
Product.Customerproductnumber
FROM insitedev.container con,
insitedev.container PARENT,
insitedev.customer customer,
insitedev.container FRESH,
------解决方案--------------------
PS:不知道为什么第二个SQL里面会出现那么多的insitedev.container ,有点点奇怪!
问题一 :vs2003.net如何配置环境才能括号配对,就是我光标所在的括号自动和与之配对的括号高亮显示。
问题二 :请问哪位知道这段query里的PARENT和FRESH是什么意思
SELECT PARENT.containername,
customer.customername,
customer.description,
FRESH.customerlotnumber,
PARENT.qty,
PARENT.targetdevice,
con.containername as SubLot,
con.qty as SubQty,
con.customerlotnumber as SubCustLot,
con.datecode as SubDateCode,
tap.qtyperreel,
FRESH.containername as FreshLot,
product.customerspecificinfo2 as COO,
con.customerorder,
con.custmotherwo,
pac.packagetypename,
smd.shipmentdestinationname,
dim.dimensionname,
lea.leadcountname,
pac.packagetypename || '-' || dim.dimensionname || '-' ||
lea.leadcountname as PDL,
Product.Customerproductnumber
FROM insitedev.container con,
insitedev.container PARENT,
insitedev.customer customer,
insitedev.container FRESH,
------解决方案--------------------
PS:不知道为什么第二个SQL里面会出现那么多的insitedev.container ,有点点奇怪!