RE: Tiered Dot Notation in where clause query of Queries (QoQ)

2009-01-23 Thread Adrian Lynch
; From: Justin T [mailto:jus...@treherconsulting.com] > Sent: 23 January 2009 17:43 > To: cf-talk > Subject: Tiered Dot Notation in where clause query of Queries (QoQ) > > Hi, > > I was just wondering what the reason is behind the error I get when I > use dot notation with QoQ

Tiered Dot Notation in where clause query of Queries (QoQ)

2009-01-23 Thread Justin T
Hi, I was just wondering what the reason is behind the error I get when I use dot notation with QoQ in the where clause. This will throw an error: select * from a.qry where a.qry.fkPOCId = 1 This won't: select * from goodQry where goodQry.fkPOCId = 1 It seems that anything beyond a s