I have found using simple queries in Access, then using a final query to pull the data together the only way to solve some problems. But how can this be represented in SQL for outside access without using a stored query?
the SQL that Access shows wont work, because the named queries take parameters themselves.
looks like a classic sql subquery to me, but i cant get access sql to use such a construction.
if you're still reading, the main use is to extract a stock list name of all parts of a certain type, then join this to another query which extracts a list of levels and other info from another table, but LEAVES BLANK the parts name lines which have no level info. i have not succeeded in convincing Access to do this, in one query.
the SQL that Access shows wont work, because the named queries take parameters themselves.
looks like a classic sql subquery to me, but i cant get access sql to use such a construction.
if you're still reading, the main use is to extract a stock list name of all parts of a certain type, then join this to another query which extracts a list of levels and other info from another table, but LEAVES BLANK the parts name lines which have no level info. i have not succeeded in convincing Access to do this, in one query.