MySQL Forums
Forum List  »  Spanish

Re: Consulta Multitabla
Posted by: Jorge Luis Borlando
Date: March 30, 2015 09:00AM

Jesús, muchas gracias, es a solución esperada

he usado la siguiente sintaxis real y ha funcionado según lo esperado
SELECT articu.descri,GROUP_CONCAT( DISTINCT eancod.ean___)
FROM articu
INNER JOIN eancod ON ( articu.codint = eancod.codint )
WHERE articu.codint=477427;

devolviendo
+--------+-------------------------------------------+
| descri | GROUP_CONCAT( DISTINCT eancod.ean___) |
+--------+-------------------------------------------+
| PRUEBA | 1111111111113,1111111111114,1111111111115 |
+--------+-------------------------------------------+


muchísimas gracias !

Options: ReplyQuote


Subject
Views
Written By
Posted
1951
March 29, 2015 02:36PM
823
March 29, 2015 10:21PM
Re: Consulta Multitabla
938
March 30, 2015 09:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.