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

join in access

P: 2
hi,

i want to know how i can join two fields of table1 to one single field of table2?
May 22 '07 #1
Share this Question
Share on Google+
2 Replies

Rabbit
Expert Mod 10K+
P: 12,441
hi,

i want to know how i can join two fields of table1 to one single field of table2?
You create an update query that concatenates the two fields and appends it to the field in table2. Whether or not this is good database design is a different matter.
May 22 '07 #2

jamjar
P: 50
Or concatenate the fields in the join expression:

Expand|Select|Wrap|Line Numbers
  1. SELECT T1.F1, T1.F2, T2.F1
  2. FROM T1 INNER JOIN T2 ON (T1.F1 & T1.F2) = T2.F1;
  3.  
James
May 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.