Re: Insert data in two columns same table

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 3/16/2016 7:07 PM, drum.lucas@xxxxxxxxx wrote:

1 - select the billable_id: (SELECT1)

SELECT billable_id FROM junk.wm_260_billables2 WHERE info ilike '%Alisha%'

2 - select the mobiuser_id: (SELECT2)

SELECT id FROM public.ja_mobiusers WHERE name_first LIKE 'Alisha%' AND name_last LIKE 'Dadryl%'

3 - Insert those two data into the dm.billables_links table (EXAMPLE):

INSERT INTO dm.billables_links (billable_id, mobiuser_id) VALUES (SELECT1, SELECT2);

assuming those two queries 1 and 2 return multiple rows, which rows of junk.wm_260_billables2  match up with what rows of public.ja_mobiusers  ?

your schema is very poorly defined.  I think you need to take a class in relational database design and usage, or read a good book on it at least..

 
the *CORRECT* SOLUTION WOULD BE MORE LIKE

INSERT INTO dm.billables_links (billable_id, mobiuser_id) SELECT b.billable_id, m.id from billables b inner join ja_mobiusers m on b.billable_id = ... where ......

I left ... in because your code fragments are referencing fields that aren't even IN your tables, and your tables don't have sane references.

-- 
john r pierce, recycling bits in santa cruz