Try this


Select a,b,c,d,e,f from
(
(SELECT a, b, c, d, e, f, DATE
FROM table1 WHERE a=10 AND b=1)
UNION
(SELECT a, b, c, d, e, f, DATE
FROM table1 WHERE a=11 AND b=1)

Glad I could help. Can you mark the thread solved if your problem has been fixed.

Thanks.

The first thing you need to do is replace the left join with an Inner join. Right now you are joining all the customers even if they do not have any orders which is a waste of resources when you are...

I know this thread is a few days old but if you want the top 10 from the combined list you just sort the list after the unions not for each table.


(SELECT * from table_a )
union (SELECT * FROM...

I think the best way is the syntax you feel more comfortable with.

I like the old joining syntax using the where clause but alot of people like the new syntax, I believe because of readability...

Im glad i could atleast point you in the right direction. good luck with the rest.

Try this


SELECT MAKE.MAKE, MAKE.count, color.Color, color.count
FROM(
SELECT MAKE, count(*)count
FROM cars
Group by MAKE
)MAKE,
( SELECT MAKE, color,...

Nevermind, I take it the attachment is the table schema.

Is it important to do it all in one query. What are you using the resultset for because if you do it in one query you will most likely get...

Since you didn't give too much information I thought of a few other interpetations of what you asked.

If field1 is a numeric value you might want the sum of the field grouped by field2


Select...

do you mean something like this


Select field2,count(Field1)
From Table
Group by field2

Their is no way to control flow with Case in SQL so the easy answer to your question is no it is not possible.

Its an easy search

http://msdn.microsoft.com/en-us/library/ms181765.aspx