# Mysql multiple tables@once help

**URL:** <https://forum.kirupa.com/t/mysql-multiple-tables-once-help/148416>\
**Category:** Uncategorized\
**Created:** [May 19, 2005, 6:24pm UTC](https://forum.kirupa.com/t/mysql-multiple-tables-once-help/148416 "2005-05-19T18:24:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![andr\_in](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/andr_in/32/37_2.png) [@andr\_in](https://forum.kirupa.com/u/andr_in)\
**Post date:** [May 19, 2005, 6:24pm UTC](https://forum.kirupa.com/t/mysql-multiple-tables-once-help/148416/1 "2005-05-19T18:24:08Z")

</div>

So I’m trying to make this search engine for my blog…  
And I need to get stuff from 2 tables: “entries” and “comments”. Each of these tables has a “date” field indicating when the entry/comment was submitted  
I need to mix them and order by date…

And I need to do this using one query… I tried 2 separate ones and them ordering them somehow and checking each one’s date and stuff but then my page-system wouldn’t work. (displaying them on separate pages)

so basically… I need to get data from 2 mysql tables, mix them up and order them by date… how would I do that?