Y
Yumex85
Hi, everyone.
I´m trying to come up with a query in acces with 3 tables, it looked
simple at the beginning, but I just can´t do it.
table1
id1
id2
date
table 2
id1
id2
idnumber
relationship table2 1 to N table1
table3
idnumber
date
value
id1 and id2 are double index in table1 and table2
idnumber and date r double index in table 3
so here it is what i wanna find out:
I wanna know which values in table3 r not registered where
table3.idnumber = table2.idnumber and table3.date = table1.date. The
problem is that idnumber and date r double primary key, i gotta make a
query that would compare both columns at the same time and tell me if
there is a register or not.
I could make a temporary table inner joining table1 and table2 and
then make a left join with table3 and temp table....but i would like
to avoid temp tables...
any suggestions? ideas?
I´m trying to come up with a query in acces with 3 tables, it looked
simple at the beginning, but I just can´t do it.
table1
id1
id2
date
table 2
id1
id2
idnumber
relationship table2 1 to N table1
table3
idnumber
date
value
id1 and id2 are double index in table1 and table2
idnumber and date r double index in table 3
so here it is what i wanna find out:
I wanna know which values in table3 r not registered where
table3.idnumber = table2.idnumber and table3.date = table1.date. The
problem is that idnumber and date r double primary key, i gotta make a
query that would compare both columns at the same time and tell me if
there is a register or not.
I could make a temporary table inner joining table1 and table2 and
then make a left join with table3 and temp table....but i would like
to avoid temp tables...
any suggestions? ideas?