Andras -
If you create an additional table which contains all possible values
for the order_status field, you can do this. Something like this:
create table orderstatus (
statusname varchar(25) );
insert into orderstatus (statusname) values ('pending'),
('processing'), ('shipped');
Next yo
Hello,
I would like merge this 3 query into a single one...
SELECT COUNT(*) AS count FROM orders WHERE order_status = 'pending',
SELECT COUNT(*) AS count FROM orders WHERE order_status = 'processing',
SELECT COUNT(*) AS count FROM orders WHERE order_status = 'shipped',
I could do :
SELECT orde
