Query two different tables in the same select

Question

I need to perform a search in two different tables and give echo in the results separately! I think it would be something more or less like this:

$consulta = "SELECT * FROM tabela1 T1 UNION (SELECT* FROM tabela2 T2)";
$con = mysqli_query ($db,$consulta);
while ($Dado = mysqli_fetch_array($con)) {
  echo $DadosT1; // Aqui resultado da primeira tabela
  echo $DadosT2; // Aqui resultado da segunda tabela
}

Can anyone enlighten me if this is possible and how it does?

Answer 1

Couldn’t you accomplish separately to achieve your goal? Something like:

$consulta = "SELECT * FROM tabela1";
$con = mysqli_query ($db,$consulta);
while ($Dado = mysqli_fetch_array($con)) {
  echo $Dado; // Aqui resultado da primeira tabela
}

$consulta = "SELECT* FROM tabela2 T2";
$con = mysqli_query ($db,$consulta);
while ($Dado = mysqli_fetch_array($con)) {
  echo $Dado; // Aqui resultado da segunda tabela
}

I’m sorry I didn’t understand your objective correctly.