var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query of more information than two tables holds
I'm wonder how I can make an view that explains both whats in a table (after certain criteria) as well as what's not there:
Table a contain all hours for a week
Table b contaion information for some hours for the same week
Hown can I make a sql sentence that give information about what's common (both in a and b) as well as information that is only in one of the tables (e.g. only in table a)
Can you throw in some sample data to explain ?
From what I could understand, UNION can be used with OUTER JOIN. But again, if you can explain it with data, will be able to tell the exact solution.
Table A will contain :
every hour within a year e.g:
Table b will have certain information, but the common information is that date stamp.
So what I want to produce is a view that will conatin something like
the "hour stamp":
"hour stamp", is_it_in_table_a, is_it_in_table_b, whats_the_table_b_s_value