Subject | KeyLinks and Table Aliases |
---|---|
Author | Matt Nielsen |
Post date | 2003-06-06T00:07:52Z |
If I have a Query with the following
SELECT T1.ID, T2.ID
FROM TABLE1 T1
LEFT OUTER JOIN TABLE1 T2
ON (T1.ID = T2.PARENTID)
The proper KeyLinks value is T1.ID not TABLE1.ID. However the system
gives me an error that this is an invalid keylinks.
What am I doing wrong? I can' imagine that noone out there is doing
tree type joins and using aliases.
Thanks,
Matt
SELECT T1.ID, T2.ID
FROM TABLE1 T1
LEFT OUTER JOIN TABLE1 T2
ON (T1.ID = T2.PARENTID)
The proper KeyLinks value is T1.ID not TABLE1.ID. However the system
gives me an error that this is an invalid keylinks.
What am I doing wrong? I can' imagine that noone out there is doing
tree type joins and using aliases.
Thanks,
Matt