No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
[COLOR=#0000ff]UPDATE[/COLOR][COLOR=#000000] table1 [/COLOR] [COLOR=#0000ff]SET[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC] [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#808080]([/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]SELECT[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC][/COLOR] [COLOR=#0000ff]FROM[/COLOR][COLOR=#000000] tmptable[/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] tmptable[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] table1[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN[/COLOR][COLOR=#808080])[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] [/COLOR][COLOR=#808080]EXISTS [/COLOR][COLOR=#808080]([/COLOR] [COLOR=#0000ff]SELECT[/COLOR] ID[COLOR=#808080],[/COLOR][DESC] [COLOR=#0000ff]FROM[/COLOR] tmptable [COLOR=#0000ff]WHERE[/COLOR] tmptable[COLOR=#808080].[/COLOR]ID_SUN [COLOR=#808080]=[/COLOR] [Table1][COLOR=#808080].[/COLOR]ID_SUN[COLOR=#808080])[/COLOR] [COLOR=#808080]I tired this but i coudn't uptade tow columns at once[/COLOR] [COLOR=#808080]do i need to seperate them or i have any mistake? …
|