From: <glassfish_at_javadesktop.org>
Date: Thu, 10 Jul 2008 10:04:35 PDT

There isn't any relation ship between those two so I had to rewrite the query like this and it solved the issue.

[b]SELECT OBJECT(pcv) FROM ProductCatalogView pcv,ProgramProductSTG ppstg WHERE pcv.productId = ppstg.productId AND ppstg.bpomPrgNbr = ?1[/b]

Thanks
Suneel
[Message sent by forum member 'suneelgv' (suneelgv)]

http://forums.java.net/jive/thread.jspa?messageID=285728