Page 1 of 1
consulta mysql, disculpen si no es aca donde hay que hacerla
Posted: Tue Aug 11, 2020 8:51 am
by goosfancito
tengo dos tablas:
Code: Select all
tb1: id, codigo1, codigo2, nombre
tb2: id, precio, item
por cada registro de tb1 existe un codigo1 y codigo2 que dependen de "tb2"
Code: Select all
tb2:
id 1
precio $10
item 8
id 2
precio $20
item 1
tb1:
id 1
codigo1 2 (o sea precio $20 e item 1)
codigo2 1 (o sea precio $10 e item 8)
mi pregunta: como se haria la consulta? para que traiga todos los datos?
Code: Select all
#define consulta;
"SELECT "+;
"tb1.id as c1, " +;
"tb1.codigo1 as c2, " +;
"tb1.codigo2 as c3, " +;
"tb2.id as c4, "+;
"tb2.precio as c5, "+;
"tb2.item as c6" +;
"SELECT tb1 " +;
"LEFT JOIN tb2 on tb1.codigo1 = tb2.id " .....
y hasta aca llego, porque no se como hacer el left join para "tb1.codigo2 = tb2.id"
gracias.
Re: consulta mysql, disculpen si no es aca donde hay que hacerla
Posted: Tue Aug 11, 2020 3:31 pm
by Francisco Horta
Goosfancito,
yo lo hago asi:
SELECT mov.*,articulos.receta, articulos.costopromedio, articulos.idalmacen_s
FROM movimientos mov
LEFT OUTER JOIN ventas ON mov.idticket = ventas.id
LEFT OUTER JOIN articulos ON mov.id = articulos.id
WHERE ventas.corte = '0' ORDER BY id,orden
ya nomas lo adaptas al tuyo,
saludos
Re: consulta mysql, disculpen si no es aca donde hay que hacerla
Posted: Tue Aug 11, 2020 6:51 pm
by goosfancito
gracias
Re: consulta mysql, disculpen si no es aca donde hay que hacerla
Posted: Wed Aug 12, 2020 2:06 pm
by nageswaragunupudi
Code: Select all
TEXT INTO cSql
SELECT tb1.id as ID, tb1.code1 as CODE1, tb1.code2 as CODE2,
tb2a.id as ID1, tb2a.price as PRICE1, tb2a.item as ITEM1,
tb2b.id as ID2, tb2b.price as PRICE2, tb2b.item as ITEM2
FROM tb1
LEFT OUTER JOIN tb2 AS tb2a ON tb1.code1 = tb2a.id
LEFT OUTER JOIN tb2 AS tb2b ON tb1.code2 = tb2b.id
ENDTEXT
Re: consulta mysql, disculpen si no es aca donde hay que hacerla
Posted: Wed Aug 12, 2020 3:38 pm
by goosfancito
thank's