Inboy
|
| Posted: 01/29/2002, 7:53 AM |
|
Anyone ever seen anything like this?
SELECT ProductID,ProductName,ReorderLevel,LeadTime sum (UnitsReceived -UnitsSold -UnitsShrinkage) as stock
FROM products group by ProductID
WHERE ProductName="'&Request.Querystring("search")&"' AND stock>0
Tried to translate it from an access query. What am I doing wrong?
|
|
|
 |
Chris S
|
| Posted: 01/29/2002, 8:14 AM |
|
Try this:
SELECT ProductID,ProductName,ReorderLevel,LeadTime, sum (UnitsReceived -UnitsSold -UnitsShrinkage) as stock
FROM products
WHERE ProductName="'&Request.Querystring("search")&"' AND stock>0
group by ProductID, ProductName, ReorderLevel, LeadTime
|
|
|
|
Chris
|
| Posted: 01/29/2002, 9:48 AM |
|
Just noticed something try this instead:
SELECT ProductID,ProductName,ReorderLevel,LeadTime, sum(UnitsReceived -UnitsSold -UnitsShrinkage) as stock
FROM products
WHERE ProductName='" & Request.Querystring("search")& "' AND stock>0
group by ProductID,ProductName,ReorderLevel,LeadTime
|
|
|
|
|
