Hi Fred, Here is another little one, I have quoted everything and come up with this
SELECT * FROM "groupmembership" WHERE "user" = 1 AND EXISTS ( SELECT "groupcapability"."group" FROM "groupcapability", "groupmembership" WHERE "groupcapability"."group" = "groupmembership"."group" AND "capability" = 0) Error reported by jdbc driver Column not found: S0022 Column not found: group in statement [SELECT * FROM "groupmembership" WHERE "user" = 1 AND EXISTS ( SELECT "groupcapability"."group" FROM "groupcapability", "groupmembership" WHERE "groupcapability"."group" = "groupmembership"."group" AND "capability" = 0)] Is there an obvious way around this problem? cheers timp On Saturday 25 May 2002 17:22, Fred Toussi wrote: > Thanks Tim, > > We have made a big effort to extend support for SQL and JDBC standards as > well as improvements in other areas so that HSQLDB can be used with other > products with fewer problems. Please let us know about any other potential > issues. > > Fred _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
