insert statement
Database
2
Posts
2
Posters
0
Views
1
Watching
-
in an insert statement how to insert a row when all the values are not supplied please help Thanks
-
in an insert statement how to insert a row when all the values are not supplied please help Thanks
show the table name followed by the columns you have sort of
insert into table1(name, firstname) values ('Smith','Fred')where table 1 also contains the address etc Hope this helps, but I suspect you need a book on SQL before going much further.Bob Ashfield Consultants Ltd