General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Extracting Info With Select - SQL
Environment versions
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!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only