Connecting Tech Pros Worldwide Help | Site Map

LINK TWO TABLE WITH QUERY

 
LinkBack Thread Tools Search this Thread
  #1  
Old September 4th, 2006, 12:45 AM
leen
Guest
 
Posts: n/a
Default 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???


  #2  
Old September 4th, 2006, 02:45 AM
pietlinden@hotmail.com
Guest
 
Posts: n/a
Default 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)

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.