strong46202
شنبه 22 بهمن 1390, 17:25 عصر
سلام...من باید دستور DISTINC رو کجای این خط قرار بدم تا مقدار فیلد product-name رو تکرار نکنه
SELECT, [SOP Query].[rev-status], [SOP Query].status, production.[product-name]
FROM [SOP Query] INNER JOIN (production INNER JOIN [relation-product] ON
production.[product-name] = [relation-product].[pro-name]) ON
[SOP Query].[sop-code] = [relation-product].[sop-code];
SELECT, [SOP Query].[rev-status], [SOP Query].status, production.[product-name]
FROM [SOP Query] INNER JOIN (production INNER JOIN [relation-product] ON
production.[product-name] = [relation-product].[pro-name]) ON
[SOP Query].[sop-code] = [relation-product].[sop-code];