Muchas gracias Marcos!<br>por el momento no es necesario tener un orden en la salida.<br><br>Saludos,<br>Juan<br><br><br><div class="gmail_quote">El 15 de marzo de 2010 16:34, Marcos Luis Mori <span dir="ltr"><<a href="mailto:marcos.mori@bireme.org">marcos.mori@bireme.org</a>></span> escribió:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div style="font-family: Verdana; font-size: 12pt; color: rgb(0, 0, 0);">Juan,<br><br>Primer paso, pienso que es mejor copiar los archivos title.mst, title.xrf. facic.mst. facic.xrf e facic.fst para una otra área de trabajo.<br>
<br>Mira que el invertido de facic está si: <br><br><br><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; font-style: italic;">910 0 'M-'v910</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; font-style: italic;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; font-style: italic;">920 0 v30'='f(val(v920),10,0)</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; font-style: italic;">
<br>la llave primaria que se hace el relacionamento es el campo 30 de la base de datos title y de la facic. <br><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; font-style: italic;">entonces, se crea más una linea, por ejemplo<br>
<br>999 0 'id='v30/<br><br>y invierte el dicionario nuevamente,<br><br>mx facic fst=@ fullinv=facic -all now tell=1000<br><br>con eso ya si puede hacer el join a través del campo 30<br><br>para probar, utilizando esa sintaxis, <br>
<br>mx title join=facic='ID='v30/ |more <br><br>es posible verificar que el join ocurrió: <br><br><br><br>-------------------------------------------------------------------------------<br><br><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">mfn= 1 </span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 99 ®1¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">888 ®Accid Anal Prev¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">460 ®3B¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 5 ®S¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 6 ®s¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 10 ®BR1.1¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">940 ®19960702¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">950 ®RCMA¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">301 ®1969¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">302 ®1¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">330 ®CT¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">340 ®A¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">350 ®En¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">360 ®En¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">400 ®0001-4575¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">420 ®ACS¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">435 ®CIENCIAS DA SAUDE¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">440 ®TRAUMATOLOGIA¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">445 ®probe¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">445 ®unifesp¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">840 ®TRAUMATOLOGY¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">450 ®IM¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">450 ®BA¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">490 ®Oxford¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">800 ®C.C¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 3 ®LOCAL¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 20 ®000456-1¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 37 ®2¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 50 ®C¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">180 ®Accid Anal Prev¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 30 ®2¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">100 ®Accident analysis and prevention¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">140 ®Association for the Advancement of Automotive Medicine¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">150 ®Accid. anal. prev¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">480 ®Pergamon Press¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">310 ®GB¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">380 ®B¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 40 ®SECS¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 40 ®CCN¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">941 ®20060906¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">951 ®RENAN¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><br>
<span style="color: rgb(204, 0, 0);">32001 ®facic^l1^kID=2^o1^m271647¯</span></span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">910 ®Q1V4F¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 30 ®2¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">920 ®1000¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">911 ®1970¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">912 ®2¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">913 ®1¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">914 ®P¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">915 ®1¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 5 ®S¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 6 ®f¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 10 ®BR1.1 ¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">940 ®20011108¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">950 ®JB¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">941 ®20011108¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">951 ®JB¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><br>32001 ®facic^l1^kID=2^o1^m271648¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">910 ®Q1V4F¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 30 ®2¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">911 ®1970¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">912 ®2¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">913 ®2¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">920 ®2000¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">914 ®A¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">915 ®0¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 5 ®S¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 6 ®f¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 10 ®BR1.1 ¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">940 ®20011108¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">950 ®JB¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">941 ®20011108¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">951 ®JB¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><br>
32001 ®facic^l1^kID=2^o1^m271649¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">910 ®Q1V4F¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 30 ®2¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">911 ®1970¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">912 ®2¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">914 ®A¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">915 ®0¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">913 ®3¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">920 ®3000¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 5 ®S¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 6 ®f¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"> 10 ®BR1.1 ¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">940 ®20011108¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">950 ®JB¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">941 ®20011108¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">951 ®JB¯</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
-------------------------------------------------------------------------------<br><br>lo que están en rojo, es de la base de datos facic. <br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">con eso, ya se puede utilizar un PFT para generar un relatório o mismo crear una base de datos. <br><br>El campo 32001 es un campo de status del join: <br>
<span style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><br>32001 ®facic^l1^kID=2^o1^m271649¯</span><br><br>solo cuando hay v32001^m es que el join fue válido<br><br>un ejemplo de generación de relatorio. <br>
<br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">mx title "join=facic='ID='v30/" "pft=v100/v110/(v912/),#" -all now tell=1000 > lista.txt<br>
<br><br>por favor, verifique si la ordenaciones de los fascículos van estar correctos, en el caso de no estar, tendremos que hacer un sort de la base de datos facic. <br><br>después le envio la sintaxis en fuera necesario. <br>
<br>Saludos, <br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);"><div class="im"><br style="font-family: Courier New,courier,monaco,monospace,sans-serif; color: rgb(204, 0, 0);">
<span><br>Marcos Luis Mori<br>PFI / Projetos e Instâncias da BVS <br>BIREME/OPS/OMS<br></span><br>----- Mensagem original -----<br>De: "Juan Gomez" <<a href="mailto:jbgomez21@gmail.com" target="_blank">jbgomez21@gmail.com</a>><br>
Para: "reddes bvs-tech" <<a href="mailto:reddes.bvs-tech@listas.bireme.br" target="_blank">reddes.bvs-tech@listas.bireme.br</a>><br></div>Enviadas: Segunda-feira, 15 de Março de 2010 14:17:31<br>Assunto: Re: [Reddes.bvs-tech] consulta listado<div>
<div></div><div class="h5"><br><br>Hola Marcos, gracias por responder...<br>Lo que necesito es hacer un listado fascículo por fascículo, pero ademas... cada fasiculo tiene q tener la informacion del titulo, por ejemplo el campo 400 que sale de la base title.<br>
Por eso hice la pregunta de como hago el join entre la base facic y la base title.<br><br>se entiende?<br><br>Saludos,<br>Juan<br><br><div class="gmail_quote">El 15 de marzo de 2010 14:04, Marcos Luis Mori <span dir="ltr"><<a href="mailto:marcos.mori@bireme.org" target="_blank">marcos.mori@bireme.org</a>></span> escribió:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div style="font-family: Verdana; font-size: 12pt; color: rgb(0, 0, 0);">Juan,<br><br>
Usted necesita hacer un listado con la base de datos facic, es decir, fascículo por fascículo o si puede con la colección resumida es decir, ej.<br>
<br><span style="font-style: italic;">1992 47 (12-13) S; 1993 48 (14-17) S; 1994 49 (18-20) S; 1995 50
(21-27) S; 1996 51 (28-32) S; 1997 52 (33-40) S; 1998 53 (41-48) S;
1999 54 (49-56,58) S; 2000 55 (59-62,64) S</span><br style="font-style: italic;"><br><br>saludos ,<br><br><br><span><br>Marcos Luis Mori<br>PFI / Projetos e Instâncias da BVS <br>BIREME/OPS/OMS<br></span><br>----- Mensagem original -----<br>
De: "Juan Gomez" <<a href="mailto:jbgomez21@gmail.com" target="_blank">jbgomez21@gmail.com</a>><br>Para: "reddes bvs-tech" <<a href="mailto:reddes.bvs-tech@listas.bireme.br" target="_blank">reddes.bvs-tech@listas.bireme.br</a>><br>
Enviadas: Segunda-feira, 15 de Março de 2010 11:13:42<br>Assunto: [Reddes.bvs-tech] consulta listado<div><div></div><div><br><br>Hola, que tal?<br>Necesito hacer un listado de las revistas que hay ingresadas en el secs junto con la informacion del titulo de las mismas.<br>
Por lo que tengo entendido secs esta formada por bases de datos, title + facic.<br>
<br>O sea que tendria que listar todo lo que esta en facic y buscar la informacion del titulo en la base title.<br>la pregunta es: con que campo/s se hace join de las 2 bases y como es la instruccion con mx para hacerlo??<br>
<br>Saludos y Gracias,<br>Juan<br>
<br></div></div>_______________________________________________<br>Reddes.bvs-tech mailing list<br><a href="mailto:Reddes.bvs-tech@listas.bireme.br" target="_blank">Reddes.bvs-tech@listas.bireme.br</a><br><a href="http://listas.bireme.br/mailman/listinfo/reddes.bvs-tech" target="_blank">http://listas.bireme.br/mailman/listinfo/reddes.bvs-tech</a><br>
</div></div></blockquote></div><br>
<br>_______________________________________________<br>Reddes.bvs-tech mailing list<br><a href="mailto:Reddes.bvs-tech@listas.bireme.br" target="_blank">Reddes.bvs-tech@listas.bireme.br</a><br><a href="http://listas.bireme.br/mailman/listinfo/reddes.bvs-tech" target="_blank">http://listas.bireme.br/mailman/listinfo/reddes.bvs-tech</a><br>
</div></div></div></div></blockquote></div><br>