By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

LINK TWO TABLE WITH QUERY

P: n/a
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???

Sep 4 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
(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)

Sep 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.