sql - Why grouping in a subquery causes problems -


When I include lines of 2 in the following subquery, it seems that this is my Sybase 12.5 ASE server then As long as there are no results, it continues till all time. The query runs fine without these 2 lines. How wrong is that grouping?

preceeded day_played.day_played = days_received.day_received and days_played.dayer_id = days_played.day_received and days_played.dayer_id = days_received.user_id where days_received.min_bulk_MT & gt; Days_played.min_MO and days_played.user_id (Select sgia.user_id as the day is shown as sgia, where sgia.day_played & lt; days_played.day_played - by group sgia.user_id - amount (sgia.b_first_msg) = 0 Saving) group by day_played.day_played

to show the explanation Does.

In this case, can not you end the sub-division by making it part of the main question?


Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -