1

Topic: Data output from the table which in this table are not present? 8-)

Good afternoon!
Here present there is one any table with an information quantity. We admit two fields ( DATE, the TOTAL ).
In this table there is an information for all month, but here, for example, for the first 10 days of the information is not present generally (is not present either dates, or the totals).
The task to deduce the information for all month, including missing first 10 days arrives.  as for 1  to push these missing lines, any any, though from a head, the information. Here such perverted job, not I the author, do not kick!). I will repeat that the table only one!

2

Re: Data output from the table which in this table are not present? 8-)

You create the second table with all days of month,  with it the first - you receive
The demanded. How to receive all the days long month - in search.

3

Re: Data output from the table which in this table are not present? 8-)

Dimitry Sibiryakov;
Thanks for the answer. Well it is an obvious variant which implies connection with other table. It is simply interesting to me, whether there is a method to make it without connection? The author hinted that this data missing there is no place to take.

4

Re: Data output from the table which in this table are not present? 8-)

Whether

Rust_Cohle wrote:

there is a method to make it without connection? The author hinted that this data missing
There is no place to take.

There would be be no place to take if their set was not countable. But days - enumerable set,
It is easy for receiving and then to use through WITH or derived table.

5

Re: Data output from the table which in this table are not present? 8-)

Rust_Cohle;
Dim enough requirements, Well make  a synonym on UNION ALL view and deduce through 1 )

6

Re: Data output from the table which in this table are not present? 8-)

ora601;
It can and meant) cannot send the approximate code? I am simple the beginner in sql. We admit Two columns (id-int, pole-int).

7

Re: Data output from the table which in this table are not present? 8-)

Rust_Cohle;
for example

8

Re: Data output from the table which in this table are not present? 8-)

Development -> As sql-inquiry to derive the information which there is not present from a database
https://habrahabr.ru/post/303364/