Timeline for Is it possible to join derived tables to actual in Access 2007
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 26, 2012 at 19:26 | comment | added | ypercubeᵀᴹ | And your link does not work (well, it works but I don't want to join that forum, just to read an example. You can copy here what it says) | |
| Jun 26, 2012 at 19:25 | vote | accept | Juan Velez | ||
| Jun 26, 2012 at 19:01 | answer | added | ypercubeᵀᴹ | timeline score: 2 | |
| Jun 26, 2012 at 18:53 | comment | added | ypercubeᵀᴹ | So, what error do you get if you run this query in Access? | |
| Jun 26, 2012 at 18:24 | history | edited | Juan Velez | CC BY-SA 3.0 |
deleted 213 characters in body
|
| Jun 26, 2012 at 18:18 | history | edited | Juan Velez | CC BY-SA 3.0 |
deleted 213 characters in body
|
| Jun 26, 2012 at 18:08 | comment | added | ypercubeᵀᴹ | Well, post an example in the question. The one you have would not work nowhere. | |
| Jun 26, 2012 at 18:06 | comment | added | Juan Velez | @ypercube Yes my queries all work in SQL. I can pass the ones that don't use Derived tables over to access just fine but the ones that do use derived tables do not work in ACCESS.... | |
| Jun 26, 2012 at 17:22 | answer | added | AmmarR | timeline score: 3 | |
| Jun 26, 2012 at 16:49 | comment | added | ypercubeᵀᴹ | Have you tried putting a code-sample (that works in SQL-Server) in Access? Did it give you an error? | |
| Jun 26, 2012 at 16:43 | comment | added | ypercubeᵀᴹ |
Your query as it is, will not in any DBMS. You have a SELECT ... FROM ... WHERE ... INNER JOIN in a subquery.
|
|
| Jun 26, 2012 at 16:27 | comment | added | Juan Velez | it seems to me like I am going to have to just create a bunch of tables or separate queries manually in Access so I can point to them and join on them in my queries as opposed to being able to write simple queries like I do in SQL server. | |
| Jun 26, 2012 at 16:19 | history | asked | Juan Velez | CC BY-SA 3.0 |