I am new to this field. Here is my issue:
I have a table named 'udat' with data and another named 'ddat' one with similar columns( column names and their type and size are same) and have to add an entire row from udat to ddat, I tried the following code- must sound crap to u:
INSERT INTO ddat values
select * from udat where id='000' )
Please take note that shammat has explicitly listed the columns in both the insert list and select lists - you should always do this too or your code can fall over after even the most minor schema change.