|
|
|
Union and order by
|
|||
|---|---|---|---|
|
#18+
Проблема в следующем select EXPENCE, UNIT, DATE_OF_PAYMENT from cash1 where id_report is null union all select EXPENCE, UNIT, DATE_OF_PAYMENT from cash2 where id_report is null order by DATE_OF_PAYMENT когда я хочу отсортировать мне вадает ошибку 'Invalid ORDER BY cause' а когда убераю сортировку нормально Как мне сортировать по дате ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.03.2004, 14:28 |
|
||
|
|
start [/forum/search_topic.php?author=Ilya.volodin&author_mode=last_posts&do_search=1]: |
0ms |
get settings: |
7ms |
get forum list: |
19ms |
get settings: |
8ms |
get forum list: |
21ms |
get settings: |
10ms |
get forum list: |
17ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
73ms |
get topic data: |
13ms |
get forum data: |
4ms |
get page messages: |
50ms |
get tp. blocked users: |
2ms |
| others: | 692ms |
| total: | 924ms |
| 0 / 0 |
