Bruce, Yes, I noticed that it might be referencing the table alias but the sql does not specify (declare?) the alias customer_f4. So, this is the incomplete SQL statement if customer_f4 is meant to be an alias.
If customer_f4 is an alias referencing the customer table then the lines > address a2 > LEFT OUTER JOIN customer_f4 ON > (a2.objectId=customer_f4.shippingAddress) should be > address a2 > LEFT OUTER JOIN customer customer_f4 ON > (a2.objectId=customer_f4.shippingAddress) right? Furthermore there is not a JOIN between customer and customer_f4 so even if the alias was defined in the sql, the result would still be incorrect. Plus, the WHERE clause of the generated sql does not make any sense as the OQL is very simple select c from sakura.data.user.Customer c there should be no where clasue that restrict the output. I think this should be caused by some mapping problem as Mickael Guessant suggested. Any Idea as to how to solve this problem? > Yasuhiko, > > This is a table alias that is generated by Castor's ParseTreeWalker to > refer to the customer table. See the following for more info: > > http://www.w3schools.com/sql/sql_alias.asp > > Bruce > -- > perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' ------------------------ Yasuhiko YOSHIKAWA [EMAIL PROTECTED] ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
