|
|
Posted by --CELKO-- on 10/01/13 11:27
>> Where do I begin? <<
Begin with the basics. Rows are not records; fields are not columns;
tables are not files. We do not write procedural code in SQL; it is a
HIGH LEVEL, declarative language. If you want to change things, you use
an UPDATE statement:
UPDATE Foobar
SET ...
WHERE foo_id IN (1,2,3,4,5);
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications. It is very hard to debug code when you do not let us
see it.
Please go to a site with SQL lessons; a newsgroup is a bad place to
learn SQL.
Navigation:
[Reply to this message]
|