Learning new SQL Tricks

[PeteAmsterdam]

I have a customer master file (CM) that contains a subset of records I culled from the production file. I would now like to copy every detail record from a production order file to a duplicate test file for which the customer number exists in CM. Here is what I've attempted so far. Actually, this is the last attempt of a dozen or so
tries:

INSERT INTO DJLIB/CUSSN
SELECT * FROM DJLIB/CUSMAS, PRODLIB1/CUSSN WITH NC
WHERE CUSMAS.CSC# = CUSSN.SNC#

This generates that there is a problem w/ my use of "WHERE"

Any ideas would be greatly appreciated.

 

[mrdenny]

Is this for a SQL Server or another platform?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[SQLBill]

I'm guessing that you aren't using SQL Server as that isn't correct syntax. There isn't any WITH NC in SQL Server's TSQL.

I suggest you post in an appropriate forum as this forum is specifically for Microsoft's SQL Server.

-SQLBill

Posting advice: FAQ481-4875