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