Just to follow up for the list readers. In my first test I had set both of the SQL view queries to 'Run SQL Direct' = TRUE, or in other words turning escape processing off. This allowed either SELECT statement to run correctly. The problem is only manifest when escape processing is on.
Also, when escape processing is on and the inner join query is run not only is the resultset incorrect, but Base makes the returned resultset updateable. Of course an attempt to actually edit the records fails. I was wondering if this might have something to do with the change made to table aliases being or not being created. I believe it was turned off by default now, and that it can be re-instated with an option. I just have no clue how to set that option for an embedded database connection. ( besides, I can't quote where I read that so perhaps I am mistaken that it is an option now, and perhaps it has nothing at all to do with this problem ) Drew On 4/15/07, Regina Henschel <[EMAIL PROTECTED]> wrote:
Hello Andrew, Andrew Jensen schrieb: > Hello Regine, [..] > Also, you can do this with the query designer > > I thought you could do it directly by adding the Personen table twice, > but that does not work, so what you do is use the Query-in-Query > feature to get this. > -- Create a query that simply selects all fields from Personen and > save it. ( qChef is what I used ) > -- Now open a new query designer > -- Add the table Personen > -- Add the QUERY qChef > -- Add the join by dragging Personen.ChefID to qChef.ID > -- Add the fields with aliases as needed > -- Save > > The result, for me using English, is identical to the your two SQL > statements here. Thanks, that works in design view. In addition I have tried using a view instead of the query; that works in design view too. kind regards Regina --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
