Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-18 : 08:31:47
|
Aleks writes "I'm having problems with the format of shaping GGC. Here is a sample of what i'm working with....
SHAPE {SELECT * FROM tblParent }
APPEND
( ( SHAPE {Select * from tblChild }
APPEND
( {Select * from tblGrandChild } AS GrandChild
APPEND
({Select * from tblGreatGrandChild } as GreatGrandChild
Relate GCID to GCID)
RELATE TO CID) )
RELATE Pid TO Pid)
AS Parent
I can't find a GreatGrandCHild example anywhere. I think there is a flaw in my format. Any help would be greatly appreciated.
Thanks" |
|
|
|
|
|
Data Shaping GreatGrandChildren