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
