Thanks but this did not work in MS Access 2002. I'm a newbee so have mercy on me, but in my example I did not have a table called "slots" nor a table called "data". Just a table called "table1" and a table called "table2". Any further clarification would be highly appreciated.
I need a SQL query to return ALL fields of Table1 and any fields from Table2 where "Slot" is equal.
Table1 has one field named "Slot" and it has 10 rows of sample data (The data = 01,02,...,10)
Table2 has three fields named "Slot" "Contents" and "Status" with the following sample data (it only...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.