SELECT * FROM [Stock] WHERE Status <> 'Sold' AND Active = 'Yes' AND [Category1] = 'Polished Fireplaces' or Status <> 'Sold' AND Active = 'Yes' AND [Category2] = 'Polished Fireplaces' or Status <> 'Sold' AND Active = 'Yes' AND [Category3] = 'Polished Fireplaces' order by StockID Desc
|
|
|||||||||||||||||
|
|
||||||||||||||||||