Timeline for Is it possible to join derived tables to actual in Access 2007
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 26, 2012 at 19:25 | vote | accept | Juan Velez | ||
| Jun 26, 2012 at 19:25 | comment | added | Juan Velez | @AmmarR Thanks! then there must be something else in my code that is not allowing the query run. I will go over my code again. The sample I gave was just a quick sample. The actual query I am trying to get to work is much longer. As long as it works in Datasheet view then I am happy. Thanks again. I really appreciate it. | |
| Jun 26, 2012 at 19:25 | comment | added | AmmarR | dear @JuanVelez i updated my main post, check it | |
| Jun 26, 2012 at 19:24 | history | edited | AmmarR | CC BY-SA 3.0 |
added 567 characters in body
|
| Jun 26, 2012 at 18:23 | comment | added | Juan Velez | This link seems to suggest that what I am asking and what you are saying is not possible... access-programmers.co.uk/forums/showthread.php?t=78833 | |
| Jun 26, 2012 at 18:19 | comment | added | Juan Velez | @ypercube I updated the example in my Question which hopefully will make things more clear. | |
| Jun 26, 2012 at 18:16 | comment | added | Juan Velez | @ypercube What does it look like when you switch into design view? How does access represent the derived table I am curious to know? Is it the same way as it represents actual tables? Can you provide an example? | |
| Jun 26, 2012 at 18:12 | comment | added | ypercubeᵀᴹ | @JuanVelez: You are wrong, Access can deal with derived tables. Just tested it, in 2003 version. | |
| Jun 26, 2012 at 18:04 | comment | added | Juan Velez | a subquery and a derived table are NOT the same thing. I am trying to join an ACTUAL table in access with a Derived table that has/needs an ALIASE name. I think ACCESS does not recognize the ALIASE name i give to the DERIVED table as being an Actual table so it does not run the query. | |
| Jun 26, 2012 at 17:59 | comment | added | AmmarR | No worried about the link you are right about that, but i tried a query similar to what was in the OP and it worked i guess that what matters | |
| Jun 26, 2012 at 17:38 | comment | added | ypercubeᵀᴹ |
I mean that the examples are only subqueries that don't have / don't need aliases and are not in the FROM clause.
|
|
| Jun 26, 2012 at 17:34 | comment | added | AmmarR | yeah the link shows example of subquery and that it exists in access, i dont see any difference when you say derived subquery or just subquery or nested select, they are just used interchangably | |
| Jun 26, 2012 at 17:28 | comment | added | ypercubeᵀᴹ | You are right, it works. But your link provides no example of a derived subquery. | |
| Jun 26, 2012 at 17:22 | history | answered | AmmarR | CC BY-SA 3.0 |