If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

We are trying to populate one table as an insert as a select from several other tables including the table that we are inserting into. It works when there are already records in the table but not on the initial insert (b/c on the conditional operator on the inserting table). Any suggestions?

i thought about that but i'm struggling with the select as. this is for a web site we're we want to show users their "tracked" items, but, when they have the option to delete their tracked items (where delete really means don't show). So i'm struggling with the initial insert vs. subsequent ones.

My java developer decided to do it as separate methods, but, here's what we were attempting to do. We have 4 tables that were pulling the rows for the tracker table, plus the need to let users flag ones as not visible in their tracker. I had the insert as select working when there were items in the table, but on the initial population it would work b/c there were no matches on the join. I think temp table (plus maybe a trigger re: the don't show flag) was the way to go b/c it would eliminated dups. Anyway thanks for your help.