LINK TWO TABLE WITH QUERY

hola..
hi..i got a problem..i have make a query for a table..the problem is..i
want to add a field from another table(i mean different table from the
table that i make the query)...but the table did not have the same
key...how can i link the two table???i have try to make a key..but it
doesnt work..is there another soluton for that???anyone can help???

re: LINK TWO TABLE WITH QUERY

(no need to shout... we can hear ya fine)
if you have two tables with no fields with values and types in common,
then you're stuck. Take a look at Northwind. the fields you join in a
query don't have to have the same name, but they need to share values
and types. Otherwise, how do you know which records in one table
belong to another? Could you post an abbreviated version of your table
structures that you're trying to query? (and the field types)