i have 2 tables table1 with columns LOGINID and NAME. table2 has columns NAME, ADDRESS, BILL_NO, DUE_AMT. Have created a new column in table2 named LOGINID and want to insert all the values of column LOGINID of table1 into the LOGINID column of table2.
I know i am writing an incorrect update command :
UPDATE TABLE2 SET TABLE2.LOGINID=
(SELECT TABLE1.LOGINID FROM TABLE1, TABLE2
Now i am getting around 100 rows from the select query...how to resolve this ...i know this is simple but i donot have mcuh knowledge
pls do respnond