Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select ... Union -> com campo NULL
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00634123
Message ID:
00634143
Views:
23
então mude para:
Select {} As Data, "SALDO ANTERIOR" As Cliente, Sum(Qtdade) As Qtdade;
      From MovEstoque;
      Where Data<={31/12/2001};
   Union All;
Select MovEstoque.Data, iif(isnull(Cliente.Nome),".null.",cliente.nome) as Cliente, Sum(MovEstoque.Qtdade) As Qtdade;
      From MovEstoque Left Outer Join Cliente On MovEstoque.Cliente = Cliente.Codigo;
      Where Data>{31/12/2001};
   Order By 1 Into Table MyTable
ehehehhehehe

Agora quanto a performace, realmente cai, mas não acredito que tenham muitos 486 por ai :D
Cordialmente,

Fabiano Costa
Previous
Reply
Map
View

Click here to load this message in the networking platform