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

Query 3 seperate tables

P: n/a
I need to perform a query against 3 tables, All the tables contain the
fields, name and position and have the same foreig key which is project
ID How can I do this and present this in a view?

Thanks.

Mar 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Fendi Baba" <ef*****@epitome.com.sg> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...
I need to perform a query against 3 tables, All the tables contain the
fields, name and position and have the same foreig key which is project
ID How can I do this and present this in a view?

Thanks.


Create and save a union query on the tables and then query the union query.

Keith.
www.keithwilby.com
Mar 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.