#1248 - Every derived table must have its own alias

Question

I have the following query:

    SELECT tb_fifeiroInscricao.*,
       tb_pagseguro.StatusTransacao,
       tb_fifeiro.ds_nome,
       tb_fifeiro.gametag
FROM tb_fifeiroInscricao
LEFT JOIN
  (SELECT MAX('tb_pagseguro.id_pagamento')
   FROM tb_pagseguro
   GROUP BY tb_pagseguro.Referencia)
INNER JOIN tb_fifeiro ON (tb_fifeiroInscricao.id_fifeiro = tb_fifeiro.id_fifeiro)

And it's giving this error:

#1248 - Every derived table must have its own alias

-1 because you have failed to Google the error message and stumble on *many* StackOverflow questions answered. — ApplePie, Nov 14 '13 at 01:36
Apart from the syntactical error you have another error. You are not using in any way the data from the left join. You'll have to rethink your query. — Mosty Mostacho, Nov 14 '13 at 01:39

Mark · Answer 1 · 2013-11-14T01:42:36.853

0

Try this:

SELECT tb_fifeiroInscricao.*,
       tb_pagseguro.StatusTransacao,
       tb_fifeiro.ds_nome,
       tb_fifeiro.gametag
FROM tb_fifeiroInscricao
LEFT JOIN
  (SELECT MAX(tb_pagseguro.id_pagamento)
   FROM tb_pagseguro
   GROUP BY tb_pagseguro.Referencia) tb1
   ON tb1.id_pagamento = tb_fifeiroInscricao.id_pagamento
INNER JOIN tb_fifeiro ON (tb_fifeiroInscricao.id_fifeiro = tb_fifeiro.id_fifeiro)

1st: you don't have aliases for your tables/sub-queries.

2nd: you don't have condition for your LEFT JOIN.

edited Nov 14 '13 at 01:42

answered Nov 14 '13 at 01:36

Mark

8,046
15
48
78

Why did you replace `tb_fifeiroInscricao` with `tb1`? – Mosty Mostacho Nov 14 '13 at 01:37
@MostyMostacho, because I put a `tb1` as alias of the sub-query. – Mark Nov 14 '13 at 01:37
The join is on `tb_fifeiroInscricao`. Not in the derived table. You're changing the logic of the statement. – Mosty Mostacho Nov 14 '13 at 01:39
I stand corrected. I don't noticed the LEFT JOIN – Mark Nov 14 '13 at 01:40
Ok but after the edit `tb1.id_pagamento` will result in another error because you're not exporting field `tb1.id_pagamento` :) – Mosty Mostacho Nov 14 '13 at 01:41

score 0 · Answer 2 · answered Nov 14 '13 at 01:44

Try this:

SELECT tb_fifeiroInscricao.*,
   tb_pagseguro.StatusTransacao,
   tb_fifeiro.ds_nome,
   tb_fifeiro.gametag
FROM tb_fifeiroInscricao tb1
LEFT JOIN
(SELECT MAX(tb_pagseguro.id_pagamento)
FROM tb_pagseguro
GROUP BY tb_pagseguro.Referencia) tb2
ON tb1.id_pagamento = tb2.id_pagamento
INNER JOIN tb_fifeiro tb3 ON (tb1.id_fifeiro = tb3.id_fifeiro)

#1248 - Every derived table must have its own alias

2 Answers2