Does Select UserName,Sname,MobileNo,Msg,Typ,Lan,Stat from Generate where (Username='blah') AND (SName='BlahBlah') And (Stat='Q')
returns anything? On Sun, Mar 29, 2009 at 5:23 PM, Jeena Ajiesh <[email protected]> wrote: > Hi all, > Please help me in this SQL Query. Wen i run it, it shows "Query has executed > Successfully" > But the row has not been inserted into the table. > > Here is the Query: > > Insert into SSM > (Username,Sname,MobileNo,Msg,Typ,Lan,Flag) > Select UserName,Sname,MobileNo,Msg,Typ,Lan,Stat > from Generate > where (Username='blah') AND (SName='BlahBlah') And (Stat='Q') > > Can anyone help in this situation. > > -- > **************** > Regards, > ♪♥♫♥Ĵєєήǎ ♫♥♪♥ > Email: [email protected] > [email protected] > [email protected] > > -- Best Regards, David Shen
