我正在使用SQL查询来填充来自2个关联表的数据表。第一个表有Products,第二个表有关联的addonpackages。当我遍历我的产品时,我能够获得第一个产品的所有addonpackages,但之后数据表只会填充最后一个每个产品的addonpackage。即:产品1 - 所有6个包装都添加到数据表产品2中 - 只有包装6被添加到数据表中产品3 - 只有包装6被添加到数据表中数据表 ......等等 我的查询如下。任何想法,为什么我得到第一个产品的所有信息,但只是所有其他产品的最后一项。无论我首先查询哪种产品,我都会获得所有相关数据,但只能获取所有其他数据。预先感谢您提供任何帮助。 选择 Products.ProductNumber,Products.Name,Products.Mnemonic,AddOnPackages.PackageNumber, AddOnPackages.Name AS PackName,AddOnPackages.Mnemonic AS PackMnem FROM AddOnPackages RIGHT OUTER JOIN 产品ON AddOnPackages.ProductNumber = Products.ProductNumber WHERE (Products.Name = @ProdName) ORDER BY Products.ProductNumber,AddOnPackages.PackageNumber
I am using a SQL query to fill a datatable from 2 associated tables. The first table has Products and the second has associated addonpackages. When I loop through my Products I am able to get all of the addonpackages for the first product but after that the datatable is only getting populated with the last addonpackage for each product. ie:product 1 - all 6 packages are added tp the datatableproduct 2 - only package 6 is added to the datatableproduct 3 - only package 6 is added to the datatable...and so onMy query follows. Any ideas of why I am getting all of the info for the first product but just the last item for all others. No matter which product I would query first, I get all of the associated data with it but only the last for all others. Thanks in advance for any help.SELECT Products.ProductNumber, Products.Name, Products.Mnemonic, AddOnPackages.PackageNumber, AddOnPackages.Name AS PackName, AddOnPackages.Mnemonic AS PackMnemFROM AddOnPackages RIGHT OUTER JOIN Products ON AddOnPackages.ProductNumber = Products.ProductNumberWHERE (Products.Name = @ProdName)ORDER BY Products.ProductNumber, AddOnPackages.PackageNumber
推荐答案您好CEB3088, 请将查询更改为以下内容,然后重试。 选择 Products.ProductNumber,Products.Name,Products.Mnemonic,AddOnPackages.PackageNumber, AddOnPackages.Name AS PACKNAME,AddOnPackages.Mnemonic AS PackMnem FROM产品RIGHT OUTER JOIN &NBSP ; AddOnPackages ON AddOnPackages.ProductNumber = Products.ProductNumber WHERE (Products.Name = @ProdName) ORDER BY Products.ProductNumber,AddOnPackages.PackageNumber 最好的问候, Alex Liang Hi CEB3088,Please change the query to the following and try again.SELECT Products.ProductNumber, Products.Name, Products.Mnemonic, AddOnPackages.PackageNumber, AddOnPackages.Name AS PackName, AddOnPackages.Mnemonic AS PackMnemFROMProducts RIGHT OUTER JOIN AddOnPackages ON AddOnPackages.ProductNumber = Products.ProductNumberWHERE (Products.Name = @ProdName)ORDER BY Products.ProductNumber, AddOnPackages.PackageNumberBest regards,Alex Liang
更多推荐
使用For循环填充数据表
发布评论