• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1003
  • Last Modified:

MSSQL query

i am using below custom SQL query
StockStatus > 0


now i want to create submenu, example perfume, category ID is 1842
i want to display all perfumes StockStatus > 0

I tried these different Code setups...and doesnt work
ProductCode IN (
SELECT ProductCode
WHERE Products_Joined.StockStatus > 0
AND Products_Joined.CategoryID = '1842'
)


StockStatus > 0 AND CategoryID = '1842'


SELECT ProductCode
WHERE Products_Joined.StockStatus > 0
AND CategoryID = '1842'


SELECT Products_Joined.ProductCode
FROM Products_Joined
JOIN Products_CategoryIDs ON Products_CategoryIDs.ProductID = Products_Joined.ProductID
WHERE Products_Joined.StockStatus > 0 AND Products_CategoryIDs.CategoryIDs = '1842'



can someone tell which sql query will do this
0
ammadeyy2020
Asked:
ammadeyy2020
1 Solution
 
Vijaya Reddy Pinnapa ReddyCommented:
Can you post error details
0
 
ammadeyy2020Author Commented:
i am using volusion shopping cart www.volusion.com
so i am getting there custom error asking to contact customer service
and they are unable to give any help regarding this
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
we will need the exact error message that you get, otherwise we cannot solve this error...
0
 
Anthony PerkinsCommented:
can someone tell which sql query will do this
I don't think so.  While there are many here that are very technically proficient, I don't know anyone that can read a crystal ball.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now