Join queries now not updateable. Need HELP

I have 2 queries that are updateable until I join them.

My first query is of a table that has a float field (lets call it SDL) that
is not unique. In this query I am doing a select where one field is like
"R*" to try and get rid of the duplicate SDL's.

My second query I have a table with the SDL field as the primary key. There
are fewer SDL numbers in my table than are in my first query.

I am joining both queries where the SDL fields are equal. Both queries are
updateable until I join them together.

below are the 2 queries:
1st qry
SELECT DISTINCT Components.ComponentIndex, CommonData.ReportedLineNo,
Components.solodatalink
FROM Components INNER JOIN CommonData ON Components.CommonDataLink =
CommonData.CommonDataLink
WHERE (((Components.ComponentIndex) Like "r*"));

2nd qry
SELECT InstIndex.SDL, InstIndex.LoopNo
FROM InstIndex INNER JOIN [Copy Of InstIndexqry] ON InstIndex.SDL = [Copy Of
InstIndexqry].solodatalink;


--
Cynthia
.

Loading