10 likes | 110 Views
UNION de tablas. LOAD A , B FROM C:BasePrb.xlsx ( ooxml , embedded labels , table is TablaA ); Right Join LOAD B , C FROM C:BasePrb.xlsx ( ooxml , embedded labels , table is TablaB ).
E N D
UNION de tablas LOADA,BFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaA);Right Join LOADB , CFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaB) LOADA,BFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaA);Left Join LOADB , CFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaB) TablaA LOADA,BFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaA);Inner Join LOADB , CFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaB) LeftTalble TablaB LOADA,BFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaA); Outer JoinLOADB , CFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaB) RightTalble LOADA,BFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaA);ConcatenateLOADB , CFROM C:\BasePrb.xlsx(ooxml, embeddedlabels, tableisTablaB)