Ayuda juntar ficheros.dbf con JOIN
Posted: Fri Mar 20, 2009 12:01 pm
Necesito Ayuda con JOIN
tengo dos bases de datos y no se juntan completamente
una STOCK.DBF INDEXADA POR REF
REF PRODUCTO TIPO PRECIO
N C C N
1 FRENOS GASOLINA 15.50
2 MORDAZA GASOLINA 16.50
3 CABLE GASOIL 23.74
4 BOMBILLAS GASOIL 25.74
la segunda base PED_CLI INDEXADA POR REF
REF MATRICULA CANTIDAD FECHA_S
N C N D
1 2345-BGH 4 01/03/2009
2 4563-CGH 5 01/03/2009
3 6754-HFG 2 15/03/2009
Tanto EN CLIPPER COMO EN dBfast
la union de las dos bases de datos en una tercera
hago lo siguiente y funciona
*------------------------------------------------------------------*
USE PED_CLI
INDEX ON ref TO PED_NUM
USE STOCK
INDEX ON ref TO STO_NUM
CLOSE DATABASES
ERASE PED_STO.DBF
SELECT 1
USE PED_CLI INDEX PED_NUM ALIAS aa
SELECT 2
USE STOCK INDEX STO_NUM
JOIN WITH aa TO PED_STO FOR REF=aa->REF
*-----------------------------------------------------------------*
la nueva base PED_STO tiene que tener los campos
REF PRODUCTO TIPO PRECIO MATRICULA CANTIDAD FECHA_S
1 FRENOS GASOLINA 15.50 2345-BGH 4 01/03/2009
2 MORDAZA GASOLINA 16.50 4563-CGH 5 01/03/2009
3 CABLE GASOIL 23.74 6754-HFG 2 15/03/2009
pero compilado con Xharbour modo consola o en Minigui
la base PED_STO solo sale los campos
REF PRODUCTO TIPO PRECIO
Un saludo
Need Help JOIN
I have two databases and did not fully meet
Indexed by a STOCK.DBF REF
REF PRODUCT TYPE PRICE
N N C C
1 BRAKE PETROL 15.50
2 Gag PETROL 16.50
3 CABLE GASOIL 23.74
4 BULBS GASOIL 25.74
second baseman PED_CLI INDEX BY REF
REF REGISTRATION NUMBER DATE_S
N C N D
1 2345-BGH 4 01/03/2009
2 4563-CGH 5 01/03/2009
3 6754-HFG 2 15/03/2009
Both CLIPPER IN DURING dBfast
the union of the two databases in third
I do the following functions
*------------------------------------------------- -----------------*
USE PED_CLI
INDEX ON TO PED_NUM ref
USE STOCK
INDEX ON TO STO_NUM ref
CLOSE DATABASES
ERASE PED_STO.DBF
SELECT 1
PED_CLI USE INDEX ALIAS PED_NUM aa
SELECT 2
USE STOCK INDEX STO_NUM
TO JOIN WITH PED_STO FOR REF aa = aa-> REF
*------------------------------------------------- ----------------*
PED_STO the new base has to have the fields
REF PRODUCT TYPE PRICE REGISTRATION NUMBER DATE_S
N N C C C N D
1 BRAKE PETROL 15.50 2345-BGH 4 01/03/2009
2 Gag PETROL 16.50 4563-CGH 5 01/03/2009
3 CABLE GASOIL 23.74 6754-HFG 2 15/03/2009
but compiled with xHarbour console mode or in MiniGui
Based PED_STO only leaves the field
REF PRODUCT TYPE PRICE
Greetings I do not speak English
tengo dos bases de datos y no se juntan completamente
una STOCK.DBF INDEXADA POR REF
REF PRODUCTO TIPO PRECIO
N C C N
1 FRENOS GASOLINA 15.50
2 MORDAZA GASOLINA 16.50
3 CABLE GASOIL 23.74
4 BOMBILLAS GASOIL 25.74
la segunda base PED_CLI INDEXADA POR REF
REF MATRICULA CANTIDAD FECHA_S
N C N D
1 2345-BGH 4 01/03/2009
2 4563-CGH 5 01/03/2009
3 6754-HFG 2 15/03/2009
Tanto EN CLIPPER COMO EN dBfast
la union de las dos bases de datos en una tercera
hago lo siguiente y funciona
*------------------------------------------------------------------*
USE PED_CLI
INDEX ON ref TO PED_NUM
USE STOCK
INDEX ON ref TO STO_NUM
CLOSE DATABASES
ERASE PED_STO.DBF
SELECT 1
USE PED_CLI INDEX PED_NUM ALIAS aa
SELECT 2
USE STOCK INDEX STO_NUM
JOIN WITH aa TO PED_STO FOR REF=aa->REF
*-----------------------------------------------------------------*
la nueva base PED_STO tiene que tener los campos
REF PRODUCTO TIPO PRECIO MATRICULA CANTIDAD FECHA_S
1 FRENOS GASOLINA 15.50 2345-BGH 4 01/03/2009
2 MORDAZA GASOLINA 16.50 4563-CGH 5 01/03/2009
3 CABLE GASOIL 23.74 6754-HFG 2 15/03/2009
pero compilado con Xharbour modo consola o en Minigui
la base PED_STO solo sale los campos
REF PRODUCTO TIPO PRECIO
Un saludo
Need Help JOIN
I have two databases and did not fully meet
Indexed by a STOCK.DBF REF
REF PRODUCT TYPE PRICE
N N C C
1 BRAKE PETROL 15.50
2 Gag PETROL 16.50
3 CABLE GASOIL 23.74
4 BULBS GASOIL 25.74
second baseman PED_CLI INDEX BY REF
REF REGISTRATION NUMBER DATE_S
N C N D
1 2345-BGH 4 01/03/2009
2 4563-CGH 5 01/03/2009
3 6754-HFG 2 15/03/2009
Both CLIPPER IN DURING dBfast
the union of the two databases in third
I do the following functions
*------------------------------------------------- -----------------*
USE PED_CLI
INDEX ON TO PED_NUM ref
USE STOCK
INDEX ON TO STO_NUM ref
CLOSE DATABASES
ERASE PED_STO.DBF
SELECT 1
PED_CLI USE INDEX ALIAS PED_NUM aa
SELECT 2
USE STOCK INDEX STO_NUM
TO JOIN WITH PED_STO FOR REF aa = aa-> REF
*------------------------------------------------- ----------------*
PED_STO the new base has to have the fields
REF PRODUCT TYPE PRICE REGISTRATION NUMBER DATE_S
N N C C C N D
1 BRAKE PETROL 15.50 2345-BGH 4 01/03/2009
2 Gag PETROL 16.50 4563-CGH 5 01/03/2009
3 CABLE GASOIL 23.74 6754-HFG 2 15/03/2009
but compiled with xHarbour console mode or in MiniGui
Based PED_STO only leaves the field
REF PRODUCT TYPE PRICE
Greetings I do not speak English