Hi
I have two tables:
Code Month
---- ------
1 January
2 February
. ...
12 December
CodeMonth Year Data
--------- ---- ----
1 2000 12
2 2000 23
1 2001 35
2 2001 19
3 2001 15
. ... ...
12 2001 25
As you can see, there are months un a year that doesn´t have data, but I need to show all months of all Years (whit null, blank...), something like this:
year Month(Literal) Data
---- -------------- ----
2000 January 12
2000 February 23
2000 March NULL
2000 April NULL
... ... ...
2000 December NULL
2001 January 35
2001 February 19
2001 March 15
2001 April NULL
2001 May NULL
... ... ...
2001 December 25
well, I know that it shows single but I don´t know how to make the query (queries) necesary...
thanks in advance
(Soy español, Si te resulta mas facil puedes contestar en español...)
I have two tables:
Code Month
---- ------
1 January
2 February
. ...
12 December
CodeMonth Year Data
--------- ---- ----
1 2000 12
2 2000 23
1 2001 35
2 2001 19
3 2001 15
. ... ...
12 2001 25
As you can see, there are months un a year that doesn´t have data, but I need to show all months of all Years (whit null, blank...), something like this:
year Month(Literal) Data
---- -------------- ----
2000 January 12
2000 February 23
2000 March NULL
2000 April NULL
... ... ...
2000 December NULL
2001 January 35
2001 February 19
2001 March 15
2001 April NULL
2001 May NULL
... ... ...
2001 December 25
well, I know that it shows single but I don´t know how to make the query (queries) necesary...
thanks in advance
(Soy español, Si te resulta mas facil puedes contestar en español...)