Reply To: autocomplete from mysql db

Hello
One thing more, i forgot that i have two databases that should take the autocomplete, one is the vendedores, two fields with vendedores name and vendedores e-mail. When searching the vendedores name and select it should autocomplete the vendedores e-mail address.
So, how can we do that when we have two tables to read from? Can we merge or make inner join or something for this? The two db tables wp_ibodt_tbl_clientes and wp_ibodt_tbl_vendedor.

I will attache some images…

Best Regards
Icemanmx