Database Discussion - how to combine data of two table into one query?

Print Page | Close Window

how to combine data of two table into one query?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17937
Printed Date: 29 March 2026 at 3:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: how to combine data of two table into one query?

Posted By: gokong
Subject: how to combine data of two table into one query?
Date Posted: 14 January 2006 at 8:04am

In microsoft access, there are two tables listed as follow:

1. Table A

ID	Num1
1	10
3	12
4	8
6	20

2. Table B

ID	Num2
2

Replies:

Posted By: zaboss
Date Posted: 14 January 2006 at 9:24am

http://www.w3schools.com/sql/sql_join.asp - http://www.w3schools.com/sql/sql_join.asp - http://www.w3schools.com/sql/sql_join.asp

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web