Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count Children in SQL Select
Message
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Title:
Count Children in SQL Select
Miscellaneous
Thread ID:
00015517
Message ID:
00015517
Views:
118
I have a parent child one to many setup
key on an index field called locindex.

Parent

locindex N 6
Station C 12


Child
locaindex N 6
Qty N 6
Price N 6

I would like to know of an SQL (2.6A FoxPro Windows) Select statement that will give me all of
the data in parent and child for only those parents with
more than one child.

Hope you all can help...TIA
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Next
Reply
Map
View

Click here to load this message in the networking platform