General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks Mark,
I was afraid of that. I haven't a clue as to how to solve this in a single query. The problem is we want to present a flat view to the user against which he can run reports (aka data warehouse). I suppose I could somehow prep the data using good ol'fashioned xBase and allow the users to play with that. Unfortunately I think this technique will not be acceptable by management. they want a "hot" view of the data. Perhaps I need to do this prep when SDT Reports is called. I would think that prepping a 10,000 record file could be a "noticable" delay.
Glenn
>Actually, I think my solution is denormalized because you have repeating information in multiple records. In general [I know your child has fixed 3 records per parent record], what you ask for is not practical in a 1-to-unknown-many because you would first have to determine how many extra fields you need based on the max number of child records for any 1 of the parent records. There is no single SQL to do what you want that would create a SQL view in VFP.
>
>If the fields from the child table are numeric, I have a solution that takes multiple SQL statements. With character data, I see no solution to what you want except maybe GenXTab, but that is still not a SQL solution.
Previous
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