<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16587" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">Tiente esse:</DIV>
<DIV style="FONT: 10pt arial"> </DIV>
<DIV style="FONT: 10pt arial">Select concat_ws("",t1.nombre," ",(select
GROUP_CONCAT(DISTINCT t2.Caracteristica ORDER BY t2.Caracteristica
SEPARATOR " ") from Table2 t2 where t2.clave like '%t1.Caracteristica%')
as NombreCompleto from Table1 t1</DIV>
<DIV style="FONT: 10pt arial"> </DIV>
<DIV style="FONT: 10pt arial"><SPAN class=e
id=q_11769a007b1653f2_3>Segue:</SPAN></DIV><SPAN class=e></SPAN></BLOCKQUOTE>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"><SPAN
class=e><FONT face=Arial size=2><STRONG>Table1</STRONG></FONT>
<DIV style="FONT: 10pt arial"><BR><BR></DIV>
<DIV style="FONT: 10pt arial">
<TABLE
style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse"
cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR>
<TD
style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 144.05pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid"
vAlign=top width=192>
<P>ID</P></TD>
<TD
style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 144.05pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid"
vAlign=top width=192>
<P>Nombre</P></TD>
<TD
style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 144.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid"
vAlign=top width=192>
<P>Caracteristica</P></TD></TR>
<TR>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 1pt solid; WIDTH: 144.05pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=192>
<P>1</P></TD>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 144.05pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=192>
<P>Cristian</P></TD>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 144.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=192>
<P>ABC</P></TD></TR>
<TR>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 1pt solid; WIDTH: 144.05pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=192>
<P>2</P></TD>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 144.05pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=192>
<P>Hugo</P></TD>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 144.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=192>
<P>BC</P></TD></TR>
<TR>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 1pt solid; WIDTH: 144.05pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=192>
<P>3</P></TD>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 144.05pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=192>
<P>Paco</P></TD>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 144.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=192>
<P>CA</P></TD></TR></TBODY></TABLE><FONT face=Arial size=2></FONT></DIV>
<DIV>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV text="#000000" bgcolor="#ffffff">
<BLOCKQUOTE type="cite"><FONT face=Arial size=2></FONT><FONT face=Arial
size=2><STRONG>Table2</STRONG></FONT></BLOCKQUOTE>
<BLOCKQUOTE type="cite">
<DIV>
<TABLE
style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse"
cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR>
<TD
style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 216.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid"
vAlign=top width=288>
<P>Clave</P></TD>
<TD
style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 216.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid"
vAlign=top width=288>
<P>Caracteristica</P></TD></TR>
<TR>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 1pt solid; WIDTH: 216.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=288>
<P>A</P></TD>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 216.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=288>
<P>Oro</P></TD></TR>
<TR>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 1pt solid; WIDTH: 216.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=288>
<P>B</P></TD>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 216.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=288>
<P>Bronce</P></TD></TR>
<TR>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: 1pt solid; WIDTH: 216.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=288>
<P>C</P></TD>
<TD
style="BORDER-RIGHT: 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; WIDTH: 216.1pt; PADDING-TOP: 0cm; BORDER-BOTTOM: 1pt solid"
vAlign=top width=288>
<P>Cobre</P></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR>El
Select que quiero lograr es uno que me regrese la informacion de esta
manera: "Cristian Oro Bronce Cobre" "Hugo Bronce Cobre" "Paco Cobre
Oro"<BR><BR>Alguna Idea?<BR><BR></DIV>
<DIV><SPAN class=gmail_quote>2008/1/11, Julio Cesar Sánchez González
<<A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:knowhow@sistemasyconectividad.com.mx"
target=_blank>knowhow@sistemasyconectividad.com.mx</A>>:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Cristian
Alberto Mejia Medina wrote:<BR>> Tengo una tabla 'usuarios' con las
columnas 'nombre' y 'tipo' donde en<BR>> 'tipo' guardo letras en base
a un catalogo ej: nombre:Cristian<BR>> tipo:ABC. Y otra tabla con el
catalogo: 'desc' y 'valor' donde tengo<BR>> tres registros: ('Oro',
'A'),('Cobre', 'C'),('Bronce', 'B'). Como<BR>> podria obtener un
select de la forma : "Cristian Oro Bronce Cobre" ????? <BR>><BR>>
--<BR>> TPI. Cristian Alberto Mejia Medina<BR>><BR>> Have a
nice day :o)<BR>>
------------------------------------------------------------------------<BR>><BR>>
_______________________________________________ <BR>> Usuarios
mailing list<BR>> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:Usuarios@mysql-hispano.org"
target=_blank>Usuarios@mysql-hispano.org</A><BR>> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://lists.mysql-hispano.org/mailman/listinfo/usuario"
target=_blank>http://lists.mysql-hispano.org/mailman/listinfo/usuario
</A><BR><BR><BR>Con un join y concatenando los campos que quieres que
formen la cadena de texto.<BR><BR><BR>--<BR>Saludos,<BR><BR>Julio Cesar
Sánchez González.<BR><BR>--<BR>Ahora me he convertido en la muerte,
destructora de mundos. <BR>Soy la Muerte que se lleva todo, la fuente de
las cosas que vendran.<BR><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://www.sistemasyconectividad.com.mx"
target=_blank>www.sistemasyconectividad.com.mx</A> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://darkavngr.blogspot.com/" target=_blank>
http://darkavngr.blogspot.com/
</A><BR><BR>_______________________________________________<BR>Usuarios
mailing list<BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:Usuarios@mysql-hispano.org"
target=_blank>Usuarios@mysql-hispano.org</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://lists.mysql-hispano.org/mailman/listinfo/usuarios"
target=_blank>http://lists.mysql-hispano.org/mailman/listinfo/usuarios</A><BR></BLOCKQUOTE></DIV>
<DIV><BR><BR clear=all><BR>-- <BR>TPI. Cristian Alberto Mejia
Medina<BR><BR>Have a nice day :o) </SPAN></DIV><PRE><HR width="90%" SIZE=4><SPAN class=q><BR>_______________________________________________<BR>Usuarios mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Usuarios@mysql-hispano.org" target=_blank>
Usuarios@mysql-hispano.org</A><BR><A onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.mysql-hispano.org/mailman/listinfo/usuarios" target=_blank>http://lists.mysql-hispano.org/mailman/listinfo/usuarios
</A><BR> </SPAN></PRE></BLOCKQUOTE>sql:<BR>SELECT * FROM usuarios u, cosas
c, usuario_cosas uc WHERE u.usuario_id = uc.usuario_id AND c.cosas_id =
uc.cosas_id<BR><BR><BR>--<BR>-- Estructura de tabla para la tabla
`cosas`<BR>--<BR><BR>CREATE TABLE IF NOT EXISTS `cosas` (<BR>
`cosas_id` int(11) NOT NULL auto_increment,<BR> `cosas_caracteristica`
varchar(30) NOT NULL,<BR> PRIMARY KEY (`cosas_id`)<BR>)
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4
;<BR><BR>--<BR>-- Volcar la base de datos para la tabla
`cosas`<BR>--<BR><BR>INSERT INTO `cosas` (`cosas_id`,
`cosas_caracteristica`) VALUES<BR>(1, 'Oro'),<BR>(2, 'Bronce'),<BR>(3,
'Cobre');<BR><BR>--
--------------------------------------------------------<BR><BR>--<BR>--
Estructura de tabla para la tabla `usuarios`<BR>--<BR><BR>CREATE TABLE IF
NOT EXISTS `usuarios` (<BR> `usuario_id` int(11) NOT NULL
auto_increment,<BR> `usuario_nombre` varchar(30) NOT NULL,<BR>
PRIMARY KEY (`usuario_id`)<BR>) ENGINE=MyISAM DEFAULT
CHARSET=latin1 AUTO_INCREMENT=4 ;<BR><BR>--<BR>-- Volcar la base de datos
para la tabla `usuarios`<BR>--<BR><BR>INSERT INTO `usuarios` (`usuario_id`,
`usuario_nombre`) VALUES<BR>(1, 'cristian'),<BR>(2, 'hugo'),<BR>(3,
'paco');<BR><BR>--
--------------------------------------------------------<BR><BR>--<BR>--
Estructura de tabla para la tabla `usuario_cosas`<BR>--<BR><BR>CREATE TABLE
IF NOT EXISTS `usuario_cosas` (<BR> `usuario_id` int(11) NOT
NULL,<BR> `cosas_id` int(11) NOT NULL,<BR> PRIMARY KEY
(`usuario_id`,`cosas_id`)<BR>) ENGINE=MyISAM DEFAULT
CHARSET=latin1;<BR><BR>--<BR>-- Volcar la base de datos para la tabla
`usuario_cosas`<BR>--<BR><BR>INSERT INTO `usuario_cosas` (`usuario_id`,
`cosas_id`) VALUES<BR>(1, 1),<BR>(1, 2),<BR>(1, 3),<BR>(2, 2),<BR>(2,
3),<BR>(3, 1),<BR>(3,
3);<BR><BR></DIV><BR>_______________________________________________<BR>Usuarios
mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:Usuarios@mysql-hispano.org">Usuarios@mysql-hispano.org</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://lists.mysql-hispano.org/mailman/listinfo/usuarios"
target=_blank>http://lists.mysql-hispano.org/mailman/listinfo/usuarios</A><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>TPI. Cristian Alberto Mejia Medina<BR><BR>Have a nice day
:o)
<P>
<HR>
<P></P>_______________________________________________<BR>Usuarios mailing
list<BR>Usuarios@mysql-hispano.org<BR>http://lists.mysql-hispano.org/mailman/listinfo/usuarios<BR></BLOCKQUOTE><BR>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>