Posts by Raul Baldner Junior • 13 points

• 1

  votes

  1

  answer

  663

  views

  Q: LEFT JOIN with WHERE in the field of the first table OR field of the second table

  SELECT COALESCE(tb2.numero_novo, tb1.numero_original) as numero FROM tb1 LEFT JOIN tb2 ON tb2.id = tb1.id WHERE tb1.numero_original = <PARAM> OR tb2.numero_novo = <PARAM> The above query…

  mysql sql performance

  asked 9 years, 5 months ago Raul Baldner Junior 13