Date: 10/06/05 (MySQL Communtiy)    Keywords: no keywords

In dealing with some odd flat files I finally have this.

TABLE A has a column called posts

TABLE B has a column called date

They both are in order so if I SELECT * FROM each and put the data side by side the date matches the post.

How can I get these two tables merged with the dates in the date column lined up with the posts in the posts column?

Source: http://www.livejournal.com/community/mysql/69932.html