FiveTech Software tech support forums

... cMsg := "SELECT c.*,g.detalle AS ngrupo,g.tipo,g.etapa,f.detalle AS netapa " cMsg += "FROM labores_maquina c " cMsg += "INNER JOIN labores_gruop g ON g.idgrupo=c.idgrupo " cMsg += "LEFT JOIN familia2 f ON f.idfamilia2=g.etapa " cMsg += "ORDER BY ngrupo,detalle" ...

... of the Buddha, who is believed to have lived in India in the 6th century BCE. The Buddha's teachings are centered around the idea of finding inner peace and happiness through the practice of mindfulness and meditation. One of the key principles of zen is the concept of "zenith," ...

... set table1.data1=oSvr.table1.data1 where condition I saw a sample on a mysql forum, but I can't make it work UPDATE database_a.clients A INNER JOIN database_b.clients B ON A.id = B.id SET B.email = A.email Any help will be appreciated From Chile. Adolfo

... := "SELECT PlanAudit.Cliente, PlanAudit.Nro_Audit, PlanAudit.Numero, Usuarios.Nombre, Usuarios.Iniciales " + ; "FROM PlanAudit INNER JOIN " + ; " Usuarios ON PlanAudit.Numero = Usuarios.Numero " + ; "WHERE (PlanAudit.Cliente = " + str( wnrocli ) + ") ...

Lo que está creando el conflicto es el INNER JOIN: cSQL := "SELECT s.id, s.Codigo, s.Codbarra, s.Descri, s.Precio_vta, s.Cantid, s.Cantid1, s.Cantid2, s.Cantid3, s.Cantid4, s.Rubro, s.Descri1, s.Marca, s.Costo, s.Minimo, s.Lote, s.Porc_iva, ...

... s.Descu4, s.Ult_prov, s.moneda, s.Disconti, m.Cotiza, dbo.Proveed.Nombre, dbo.Marcas.Nombre AS nommarca " + ; "FROM dbo.Stock AS s INNER JOIN " + ; " dbo.Monedas AS m ON s.moneda = m.Descri INNER JOIN " + ; " dbo.Proveed ON s.Ult_prov = dbo.Proveed.Numero INNER ...

... all possible combinations of three or more letters in the given word. The outer two loops iterate over all pairs of letters in the word, and the inner loop iterates over all remaining letters in the word to generate a combination of three letters. The combination is then printed on a new line. ...

cSql:= "select kxp.corte, k.descripcion, p.id, p.descripcion from P0017 p inner join P0031 kxp on kxp.producto=p.codigo inner join P0029 k on k.codigo=kxp.corte" oRs2:=oCn2:RowSet( cSql ) xBrowse( oRs2 ) ADO connection object has no method RowSet. Use: ...

... "sa", "Came0303" }, .t., oErr ) xBrowse( oCn2 ) cSql:= "select kxp.corte, k.descripcion, p.id, p.descripcion from P0017 p inner join P0031 kxp on kxp.producto=p.codigo inner join P0029 k on k.codigo=kxp.corte" oRs2:=oCn2:RowSet( cSql ) xBrowse( oRs2 ) RETURN nil Error: ...

... dbo.Stock.Precio_vta, dbo.Fichacod.Cantid * dbo.Stock.Precio_vta AS total " + chr(13) + chr(10) + ; "FROM dbo.Fichacod INNER JOIN dbo.Stock ON dbo.Fichacod.Codigo = dbo.Stock.Codigo " + chr(13) + chr(10) + ; "WHERE (dbo.Fichacod.Producto = '"+wcodigo+"')" ...

Hola, como hago para obtener una consulta de 2 tablas.

Intente con inner join y no obtengo el resultado que quiero.

Quiero tener un detalle de todos las salidas de un articulo, de la tabla de remitos y de facturas.

Saludos.
Jorge

... specified. Circular Meter: CIRCULAR [INNERDIA <nDia>] [FILLCOLOR <nInnerColor>] By default, the appearance is like a pie chart. If innerdia is specified, either in pixels or as a ratio (0.1 to 0.9) to the outer diameter, the inner cicle is painted separately with fillcolor. If no ...

... from a listbox any install / download we need ( not only 2 options ) with a double-click on the share-symbol. After a selection the title and inner section of the installer will be complete repainted. http://www.pflegeplus.com/IMAGES/Install8.jpg regards Uwe :D

... be oPen object or Color value or array of { color, thickness }. Defaults to { CLR_BLACK, 1 } uBrush: If specified, fills the area. If omitted, the inner area is left transparent. uBrush can be Brush object, nRGB color or Alpha Color, Gradient Array with RGB and Alpha colors. aText: Optional array ...

... this to work well, the SIZE <nWidth> and <nHeight> need to equal or nearly equal. By default, the appearance is like a pie chart. If innerdia is specified, either in pixels or as a ratio (0.1 to 0.9) to the outer diameter, the inner circle is painted separately with fillcolor. If ...