<div>
select * from a_messages where profile_id='username' order by message_id desc<br />
UNION <br />
select * from a_messages2 where profile_id='username' order by message_id desc
</div>


select * from a_messages where profile_id='username' order by message_id desc
UNION
select * from a_messages2 where profile_id='username' order by message_id desc

<div>
#@(*&amp;Q#(*(&amp;$ ANGELLLL!!!!!!<br />
<br />
LOL <br />
<br />
one misype :(
</div>


#@(*&Q#(*(&$ ANGELLLL!!!!!!

LOL

one misype :(

<div>
i know its a monday I wasn't quite awake yet and i dont drink coffee <br />
&nbsp; :)
</div>


i know its a monday I wasn't quite awake yet and i dont drink coffee
  :)

<div>
<a href="https://www.experts-exchange.com/M_4365474.html" rel="ugc">https://www.experts-exchange.com/M_4365474.html</a><br />
<br />
Error Code: 1221. Incorrect usage of UNION and ORDER BY<br />
<br />
<br />
second query worked<br />
<br />
thanks for explanations also
</div>


https://www.experts-exchange.com/M_4365474.html [https://www.experts-exchange.com/M_4365474.html]

Error Code: 1221. Incorrect usage of UNION and ORDER BY


second query worked

thanks for explanations also

<div>
<div class="content wysiwyg-content">
select * from a_messages where profile_id='username' order by message_id desc<br />
select * from a_messages2 where profile_id='username' order by message_id desc<br />
<br />
<br />
want one query with one result set because tables have same structure
</div>
</div>


select * from a_messages where profile_id='username' order by message_id desc
select * from a_messages2 where profile_id='username' order by message_id desc


want one query with one result set because tables have same structure

one query and one result set

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.