1,583
edits
Changes
no edit summary
surnames on their primary name, use:
SELECT primary_name.surname_list.[1 ] FROM person;
or
SELECT gramps_id, primary_name.surname_list.[1 ] FROM person WHERE col[1];
13) In a SELECT (for speed reasons), you need to reference a field before you can use it. That is not necessary in the UPDATE or DELETE statements. (The idea here is that SELECTS are done quite frequently, but UPDATES are done rarely, and it doesn't matter if those take a little longer). Maybe we can relax this constraint.
