Posts by user97429 • 26 points

• 0

  votes

  3

  answers

  1256

  views

  A: How to do an INNER JOIN bringing everything from two tables and one more "max" in a specific field?

  For this case you should use sub-query, so you only take the largest of table 2. SELECT tabela1.*,tabela2.* FROM tabela1 INNER JOIN (SELECT * FROM tabela2 WHERE pontos = (SELECT MAX(pontos) FROM…

  sql query mysqli phpmyadmin

  answered 7 years ago user97429 26