Can you paste your sql update query into a reply to this message so we
can see your execution plan.
Regards,
Len Wright
Plus International Corp
www.plusinternational.com
Direct: 604-415-2384
Fax:604-415-0830
>>> [EMAIL PROTECTED] 05/20/02 05:45PM >>>
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
