Posted by tom on 09/21/05 20:27

I am new to SQL administration.

>From a list of IDs that are the primary key in one table (i.e. Customer
Table), I want to make changes in tables that use those IDs as a
foreign key.

Basically I want to say:

If fk_ID is in list [1,2,3,4,5] then
do these statements to that record
End if

Where do I begin?

Thanks for help with this low-level view of SQL programming.

-tom

• Next in forum: Help finding the top 3 zipcodes within the top 5 counties
• Prev in forum: Renaming a Server
• Thread view: Syntax to add records if primary key = list

[Reply to this message]