Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update command ISQL

Status
Not open for further replies.
shmo

shmo

IS-IT--Management
Nov 25, 2002
18
US
How do I update a field in (table A) using data from a field from (table b) in the same database? The transact sql statement does not work in ISQL.

Help!
 
Sort by date Sort by votes
Nevermind! I figured it out...

FYI

Update table1
set table1.f1 =
select table2.f2 from table2.f2 where table1.key = table2.key
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

steverb
  • Locked
  • Question
Command line to list procedures and veiw in Database
Replies
1
Views
46
delphIBase
delphIBase
svanels
  • Locked
  • Question
How to use the update command
Replies
6
Views
61
svanels
svanels
GregH99
  • Locked
  • Question
Interbase equivalent of MSAccess First command
Replies
1
Views
27
MartijnTonies
MartijnTonies
Andislack
  • Locked
  • Question
interbase/fire-bird recplace or update?
Replies
5
Views
39
MartijnTonies
MartijnTonies
not24
  • Locked
  • Question
What function on InterBase SQL command that work like Len()
Replies
6
Views
108
not24
not24

Part and Inventory Search

Sponsor

Back
Top