Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Extracting Info With Select - SQL
Versions des environnements
Network:
Windows 2000 Server
Hello There...
I have not much experience working with Select - SQL... generally, my querys can be done with a Scan...EndScan without much trouble, but this time I have something that I think Select - SQL could be of some help. For you it will be a lame question, but I'm in a trouble now and need an answer.
I have a cursor in which I store some invoice numbers. Then I need to use those records in that cursor to extract the items that are relatives to those invoices. Happens that the items, for some reasons, are stored in two tables, so, I was trying something like this:
Select * From Detalle1 Where Detalle1.Factura = FacturaSC.Factura .and. !Delete() Union Select * From Detalle2 Where Detalle2.Factura = FacturaSC.Factura .and. !Delete() Into Cursor tmpFacturas
The resultant cursor with this sentence only shows me the items of the last invoice of the cursor (FacturaSC), but I need that the query shows me the items for every invoice in that cursor...
Can somebody explain me what and how to do it?
Thanks in advantage!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement