Re: Insert data in two columns same table

I see a lot of other problems: you have 3 independet tables. Your 2 queries
(selects) returns 2 independet results, you can't use that for insert into the
3rd table. And i think, you are looking for an update, not insert. So you have
to define how your tables are linked together (join).

Can you explain how these tables are linked together?

CREATE TABLE
    billables
    (
        billable_id BIGINT DEFAULT "nextval"('"dm"."billables_billable_id_seq"'::"regclass") NOT
        NULL,
        account_id BIGINT NOT NULL,
        code CHARACTER VARYING(64) NOT NULL,
        info "TEXT",
        CONSTRAINT pk_billables PRIMARY KEY (billable_id),
        CONSTRAINT uc_billable_code_unique_per_account UNIQUE ("account_id", "code"),
    );
CREATE TABLE
        billables_links
        (
            billable_link_id BIGINT DEFAULT "nextval"('"dm"."billables_links_billable_link_id_seq"'::
            "regclass") NOT NULL,
            billable_id BIGINT NOT NULL,
            customer_id BIGINT,
            role_id BIGINT,
            mobiuser_id BIGINT,
            CONSTRAINT pk_billables_links PRIMARY KEY (billable_link_id),
            CONSTRAINT fk_billable_must_exist FOREIGN KEY (billable_id) REFERENCES billables
            (billable_id),
            CONSTRAINT cc_one_and_only_one_target CHECK ((((("customer_id" IS NOT NULL))::INTEGER + (
            ("role_id" IS NOT NULL))::INTEGER) + (("mobiuser_id" IS NOT NULL))::INTEGER) = 1)
        );
CREATE TABLE
            ja_mobiusers
            (
                id BIGINT DEFAULT "nextval"('"ja_mobiusers_id_seq"'::"regclass") NOT NULL,
                clientid BIGINT DEFAULT 0,
[...]
                PRIMARY KEY (id),
                CONSTRAINT fk_account_must_exist FOREIGN KEY (clientid) REFERENCES ja_clients (id),
            );