Merging Data 2

[bam720]

I am trying to merge two tables I have. Im looking to do something like this, but am unsure how to do it.

INSERT INTO Checks (ID, TermID)
VALUES (SELECT DISTINCT ID FROM SALES; ,1)

Will that work, or am I thinking about this wrong?

 

[lespaul]

it needs to be structured like this (if TermID is a numeric field):

INSERT INTO Checks (ID, TermID)(SELECT DISTINCT ID, 1 FROM SALES)

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[PHV]

INSERT INTO Checks (ID, TermID)
SELECT DISTINCT ID, 1 FROM SALES

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bam720]

thank you both worked perfectly.

 

[bam720]

So I had soem key issues and need to update a time stamp. If I need to use two tables is it just:

INSERT INTO Checks (ID, TermID, Time)
SELECT DISTINCT ID, 1, Time FROM SALES,NewTime

Where Time only exists in NewTime Table? and ID only exists in Sales? Thanks again

 

[lespaul]

that would work, you can read the article linked below to see how to do it other than the cartesian join that you've used: FROM Sales, NewTime

thanks for the star!

Leslie

 

[bam720]

The link didn't work. I'd be interested in seeing alternatives...Thank you

 

[PHV]

Leslie meant this:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lespaul]

Forgot to include my signature line! thanks PHV for providing the link (bam - it was in one of my previous posts!)

leslie