Got it sorted.
UPDATE featured
Inner Join products
ON featured.products_id = products.products_id
SET featured.status = '0'
WHERE products.products_quantity = '0' and featured.status = '1'
Results 1 to 2 of 2
Hybrid View
-
25 Aug 2012, 07:36 PM #1
Inactive
- Join Date
- Jan 2012
- Posts
- 488
- Plugin Contributions
- 0
Re: SQL Update Query Help
Reply With QuoteSimilar Threads
-
v154 Help with a SQL Query for Query Builder
By lindasdd in forum Managing Customers and OrdersReplies: 2Last Post: 24 Mar 2016, 01:18 PM -
v151 Need an SQL query to select a range of products and update the product status to 0
By oztraveller06 in forum Setting Up Categories, Products, AttributesReplies: 2Last Post: 8 Mar 2014, 07:33 AM -
Bulk change to order status using SQL query for certain products?
By neo2810 in forum Managing Customers and OrdersReplies: 3Last Post: 24 Feb 2012, 08:34 PM -
Mass update product expected dates via SQL query
By misaki in forum General QuestionsReplies: 3Last Post: 22 May 2010, 01:18 AM -
Easier way to set products on Featured Products? SQL query perhaps?
By tj1 in forum General QuestionsReplies: 3Last Post: 11 Sep 2007, 05:36 AM
