[MasterWeb] MySql

[Ady Permadi]

Pren..
Ada yg tau nggak kenapa SQL syntak ini nggak jalan di mySql

UPDATE SUBSCRIBERS
SET MAXTIME =
        ((SELECT MAXTIME
       FROM SUBSCRIBERS
       WHERE USERNAME = 'ipgtest01') -
        (SELECT ACCTSESSIONTIME
      FROM ACCOUNTING
      WHERE USERNAME = 'ipgtest01' AND 
           ACCTSTATUSTYPE = 'Stop' ORDER BY TIME_STAMP Limit 1))
WHERE USERNAME = 'ipgtest01';

di MSSQL jalan ..

thanks before..

BiG



Ikutilah lomba banner flash berhadiah :
http://www.master.web.id/kreasi-banner-berhadiah.htm

-------[ Master Web Indonesia - www.master.web.id ] -------
Moderator         : [EMAIL PROTECTED]
Berlangganan      : [EMAIL PROTECTED]
Stop Berlangganan : [EMAIL PROTECTED]
-----------------------------------------------------------