Is it like SELECT A., B. FROM (SELECT * FROM TABLE WHERE

Question

Is it like SELECT A., B. FROM (SELECT * FROM TABLE WHERE

CONDDATE < TO_DATE('1999', 'YYYY')) A
LEFT JOIN
(SELECT * FROM TABLE
WHERE
CONDDATE > TO_DATE('1999', 'YYYY')) B
ON A.ID=B.ID;
?

0

17.11.2020

1 ответов

14 просмотров

Пользователь 61701 · Answer 1

Пользователь 61701 Автор вопроса

I tried this and it worked. I really have to set up my own Oracle DB instance. There's only so much of what sqlfiddle can take with my bombarded queries

0

17.11.2020

Похожие чаты

Is it like SELECT A., B. FROM (SELECT * FROM TABLE WHERE

1 ответов

Похожие вопросы

Похожие чаты

Is it like SELECT A.*, B.* FROM (SELECT * FROM TABLE WHERE

1 ответов

Похожие вопросы

Is it like SELECT A., B. FROM (SELECT * FROM TABLE WHERE