Hi,
I am having a problem in building this query, here's the situation:
I have 3 tables 'a' 'b' and 'c'
Now in 'a' there are two fields 'alias' and 'aid', in 'b' there are
two fields 'category' and 'bid' and in 'c' there are two fields 'aid'
and 'bid' (these fileds contains ids from 'a' and 'b' table where they
matched!
Now what i want to do is to get 'alias' from 'a' table of 'category'
from 'b' table where both tables' ids are matched in third table 'c'
both tables' id are placed in third table 'c'
kindly help me with the solution
database type is MS ACCESS 2003
I am having a problem in building this query, here's the situation:
I have 3 tables 'a' 'b' and 'c'
Now in 'a' there are two fields 'alias' and 'aid', in 'b' there are
two fields 'category' and 'bid' and in 'c' there are two fields 'aid'
and 'bid' (these fileds contains ids from 'a' and 'b' table where they
matched!
Now what i want to do is to get 'alias' from 'a' table of 'category'
from 'b' table where both tables' ids are matched in third table 'c'
both tables' id are placed in third table 'c'
kindly help me with the solution
database type is MS ACCESS 2003