Database Discussion - joining tables

Print Page | Close Window

joining tables

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=8708
Printed Date: 30 March 2026 at 7:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: joining tables

Posted By: k_mustard
Subject: joining tables
Date Posted: 09 January 2004 at 9:02am

i want to join 2 tables together.

table 1 = customer
table 2 = year1

So i want to take the information that is in "year1" and place it into "customer"

they both have RowID, Price, and Code columns

how do i do this??? thanks

Replies:

Posted By: michael
Date Posted: 09 January 2004 at 9:51am

You did not say if you permanetntly want to join them, the you would have to do an import on one of them, otherwise you can do

Select RowID,Price,Code from customer
Union
Select RowID,Price,Code from year1

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker