Re: [Info-Ingres] Few questions concerning Ingres 2006

At 4:01 PM -0700 4/16/07, Marek.Patrzek@xxxxxxxxx wrote:

... And Roy, I have no idea, how did you manage to do that,
as I always end up with "Table "select" does not exists or is not
owned by you"... at first, I thought that I can put all the blame on
JDBC, but than, I executed my query in a "native" way, using official
ingres 2006 RDBMS Release 2 and got same results.

Well than - what can possibly be wrong with my version of ingres, that
it DOES NOT support subqueries ?

I suspect a subtle syntax error. Subqueries in the from clause
work fine for me. (Are you perhaps trying to put a subquery
in an ON clause? I don't believe that works, although I haven't
tried it in Release 2.) Perhaps you're missing a paren or
comma somewhere. (I assume by "native" you mean you're
running it through one of the sql terminal monitors.)


A new issue - a bit off topic. I made a view which had casting
function (from varchar to integer) in the select statement. Everything
was fine, until I wanted to join my view with another table using
table.column which was an integer to some view.column which - in
theory was an integer too. Again - all I got was an error msg saying
that I got incompatible data types...

That sort of thing generally works for me. I guess
we'd have to see a specific example; perhaps you have uncovered
a bug.

Karl
.

Relevant Pages

  • Re: Correlated Sub Query with joins in the where clause
    ... If I don't use a join the query works but it doesn't allow me to ... FWIW you can do multiple joins in the FROM clause of the main query ... without using subqueries in the WHERE clause. ...
    (microsoft.public.access.queries)
  • RE: Query too Complex...
    ... It would only work if I put it into a new query. ... Should I be using subqueries? ... simplify things in the FROM clause? ...
    (microsoft.public.access.queries)
  • Re: Few questions concerning Ingres 2006
    ... Ingres has always supported subqueries. ... and Ingres may not support the particular one you want. ... SELECT tmp.* FROM... ...
    (comp.databases.ingres)
  • Re: Bizarre subquery syntax problem
    ... you've made change to a query or Access itself has made change to ... MVP - Technologies Virtual-PC ... I have been forced into using subqueries a lot, ... trouble accessing aliases defined in the FROM clause in the WHERE or ORDER ...
    (microsoft.public.access.queries)
  • Re: SELECT result as a table in from list
    ... You can use subqueries in the WHERE clause in VFP6 as well. ... >> Dennis Longfellow ...
    (microsoft.public.fox.vfp.queries-sql)