Here is what I have tried I'm closer but still no cigar. I'm headed for bed maybe something will show up by the morning.
Update courses Set courses.from_date=(select distinct course_date from course_crosslink Where courses.course_ID=course_crosslink.course_ID) Server: Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. ******************************************* Or more better I think since it is unique course_ID's I want to extract to match the ones in the courses table. Here is what I was thinking but now I'm back to the old message. In the second line it does not recognize the course_cross_link.course_date. Update courses Set courses.from_date=course_crosslink.course_date Where courses.course_ID=(select distinct course_ID from course_crosslink) Server: Msg 107, Level 16, State 3, Line 2 The column prefix 'course_crosslink' does not match with a table name or alias name used in the query. on 5/21/02 12:03 AM, Dan Stein at [EMAIL PROTECTED] wrote: >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Stein >> Sent: Monday, May 20, 2002 6:36 PM >> To: Multiple recipients of list witango-talk >> Subject: Witango-Talk: Another SQL conundrum >> >> >> I am trying to fix a screw up where my app has not been entering data. I can >> pull all this stuff into excel or FMP and then manipulate it and put it back >> but I would bet there is a way to do it with SQL. >> >> So here goes for all you guru's out there. >> >> I have a table called courses >> And a table called course_crosslink >> >> The crosslink table holds information about the course data and time so I >> can deal with multi-day courses. >> >> So problem one may be that the course_ID from courses has a one to many >> relationship with the course_ID from crosslink. >> >> What I want to do is set a column called From_Date in courses to the >> Course_Date column in crosslink. I fixed the taf so it does this properly >> when it creates the course record but now I have a legacy issue to deal >> with. >> >> 2. As a test I took my development data a created another table with >> course_ID as a primary key and no duplicate values. But the Update still >> does not work. >> >> With 288 courses I would like to do this through SQL and since it is >> supposed to go live Wednesday I am in a bit of a crunch. >> >> Dan >> >> -- >> Dan Stein >> Digital Software Solutions >> 799 Evergreen Circle >> Telford PA 18969 >> 215-799-0192 >> 610-256-2843 >> Fax 413-410-9682 >> FMP,Tango, EDI,SQL 7 >> [EMAIL PROTECTED] >> www.dss-db.com >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body >> -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 215-799-0192 610-256-2843 Fax 413-410-9682 FMP,Tango, EDI,SQL 7 [EMAIL PROTECTED] www.dss-db.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
