Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

SQL Syntax Question

Dec 29, 2000, 4:16 PM
carfac
Veteran (1240 posts)
carfac's avatar
Dec 29, 2000, 4:16 PM
Views: 3500
Shortcut
Quote Reply
SQL Syntax Question
Hi:

Thought I would ask here before I run this and ruin my data!

I want to take the CategoryID from CatLinks and copy that into the corresponding Link field CategoryNum (that I have added.) Does this look right?
In Reply To:
insert into Links (CategoryNum)
Select LinkID,CategoryID from CatLinks
where Links.ID = 'LinkID'
I am sure I do not quite have this right!

thanks!

Dave

Subject Author Views Date
Thread SQL Syntax Question carfac 3500 Dec 29, 2000, 4:16 PM
Thread Re: SQL Syntax Question 		pugdog 3388 Dec 29, 2000, 4:34 PM
Thread Re: SQL Syntax Question 		carfac 3390 Dec 29, 2000, 6:37 PM
Thread Re: SQL Syntax Question 		carfac 3376 Dec 30, 2000, 9:53 AM
Thread Re: SQL Syntax Question 		pugdog 3383 Dec 30, 2000, 9:58 AM
Thread Re: SQL Syntax Question 		carfac 3370 Dec 30, 2000, 11:13 AM
Thread Re: SQL Syntax Question 		pugdog 3367 Dec 30, 2000, 6:20 PM
Post Re: SQL Syntax Question 		carfac 3305 Dec 31, 2000, 9:43 AM