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
ammadeyy2020Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
we will need the exact error message that you get, otherwise we cannot solve this error...
0
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.