Yes I made a type but not in the query just in the email. It is in the syntax that I am off or in the concept itself. I would hate to think I have to do this by hand or moving data from an export into some other program and back.
I could do this easily in FMP because it would just take the 1st row that matches and use that value and then move on. If I have to I will do it that way I guess. Always makes for some problems when importing back in though maybe if I do a SQL update from FMP and then export my data back into the deployed SQL database from my local all will go well. Meanwhile maybe someone will save me the trouble. Dan on 5/20/02 11:18 PM, Ben Johansen at [EMAIL PROTECTED] wrote: > Hi Dan > > looks like a typo... > > you have =course.crosslink.course_ID (with a period) > shouldn't it be > course_crosslink.course_ID (with the underscore) > > Ben Johansen - http://www.pcforge.com > Authorized WiTango Reseller > http://www.pcforge.com/WiTangoGoodies.htm > latest beta downloads @ http://www.witango.ws > > -----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. > > 1, I was trying to do this which would be the easiest and I would expect it > to grab the first course_date when there were duplicate course_ID values. > > Update courses > Set courses.from_date=course_crosslink.Course_date > Where courses.course_ID=course.crosslink.course_ID > > It pareses fine but when I execute it I get the error message the column > prefix course_crosslink does not match with a table name or alias used in > the query. > > I know I have written things like this in the past and they have worked > somewhere I must be missing something I guess where I need to define the > tables but I don't know where it goes. > > > 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
