First off, I'm not trying to "join" the tables like every single website is trying to tell me to do. And if I am.. it's not working. I am trying to take two different types of "post" style tables and put them into one readers column and have them sort by date. For instance..
Table 1
Post IDPost TitlePost ContentPost Date
1Title 1Content 120111018
2Title 2Content 220111019
3Title 3Content 320111020
Table 2
Post IDPost TitlePost ContentPost Date
1Blog 1Context 120111015
2Blog 2Context 220111018
3Blog 3Context 320111020
How can I query those in the manner that they would display something like..
1, Blog 1, Context 1, 20111015
1, Title 1, Content 1, 20111018
2, Blog 2, Context 2, 20111018
2, Title 2, Content 2, 20111019
3, Title 3, Content 3, 20111020
3, Blog 3, Context 3, 20111020
Note that it's sorted by date. When joining tables, it wants me to compare the two tables. I don't want to do that.
If someone can help me, I'd greatly appreciate it.