<div>
thanks for query and thanks for performance advice
</div>


thanks for query and thanks for performance advice

<div>
<div class="content wysiwyg-content">
select * from a_messages2 where profile_id like 'kb%'<br />
union<br />
select * from a_messages where profile_id like 'kb%'<br />
order by message_text<br />
<br />
same table layout<br />
order by message_text applys to both tables<br />
<br />
I tried putting where profile_id like 'kb%' &nbsp;and got error
</div>
</div>


select * from a_messages2 where profile_id like 'kb%'
union
select * from a_messages where profile_id like 'kb%'
order by message_text

same table layout
order by message_text applys to both tables

I tried putting where profile_id like 'kb%'  and got error

2 tables same layout want to use only one where clause

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.