Grouping in SELECT

[torturedmind]

Good day to all.

I have a table say:

[tt]ordr_no ordr_qty
------- --------
P070001 5520
P070002 1833
P070003 12914
P010004 756[/tt]

Is it possible to have an output like this using just the SELECT statement?

[tt]ordr_no pckg_qty
------- --------
P070001 1000
P070001 1000
P070001 1000
P070001 1000
P070001 1000
P070001 520
P070002 1000
P070002 833
P070003 1000
P070003 1000
P070003 1000
P070003 1000
P070003 1000
P070003 1000
P070003 1000
P070003 1000
P070003 1000
P070003 1000
P070003 1000
P070003 1000
P070003 914
P010004 756[/tt]

I could do it using plain codes but is it possible to do using SELECT? Am using VFP6, btw.


kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."

 

[cbasoz]

I don't think so.

Cetin Basoz
MS Foxpro MVP, MCP

 

[torturedmind]

thanks cetin for the quick response. i never think it wasn't possible. i guess i was just being optimistic.

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."