On Fri, 09 Nov 2007 16:31:09 -0500, Jerry Stuckle
<jstucklex@attglobal.net> wrote:

>Table definitions would help...

Table type is innoDB, character set is utf-u unicode, and fields are
varchar. Each table the same where 'type' is concerned and 'area' is
always the column next to 'equipment'. Table's were originated using
default settings with phpMyAdmin 2.6.2 thanks