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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: heatmiserkmp
- Content: Threads
- Order by date
-
Need help updating a field based on join of 2 tables
update OSFXCPP set fxxest = 'O' WHERE exists (SELECT * FROM OSJ0CPP, osfxcpp WHERE J0D3DT = 1050427 AND J0AXCD = fxaxcd AND j0a7tx = fxa7tx AND J0AXCD= '409') and FXXEST = 'C' I know I am doing something wrong. I have 2 tables FRT...- heatmiserkmp
- Thread
- Replies: 6
- Forum: ANSI_SQL
-
Update database using a query for DB2
I need to "match up" data from 2 files and then change a field in one of hte files. Here is my statement: update OSFXCPP set fxxest = 'O' where (SELECT J0D3DT, FXAXCD, FXA7TX, FXXEST FROM OSJ0CPP, OSFXCPP WHERE J0D3DT = 1050427 AND...- heatmiserkmp
- Thread
- Replies: 4
- Forum: IBM: DB2
