|
RE: MS Access - How to make a query showing filtered results
I don't work much with Access and certainly not with the graphical query designer. I work a lot with SQL. It sounds like the SQL query you want is:
SELECT B.ID, B.Name FROM MyTable A JOIN MyTable B on B.ID <> A.ID WHERE A.ID = something
That *sounds* like what you want, although it is somewhat odd and you are not describing it very well.
In any case, perhaps the SQL concepts shown in this example will get you started in the right direction -- you can alias table names and that is the only way you can join the same table to itself. My Access experience is limited, but I can tell you that aliasing and joins are fully supported on SQL query level -- although I would have no idea how you go about doing this with the graphical query designer (you probably can't).
| 
