merging two data streams

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have two data pipelines in a dataflow and would like to merge them to
achieve the same thing as this sql statement:

select col1, col2, col3
from tablea
union
select col1, col2, col3
from tableb
where not exists (select 1 from tablea where tablea.pk = tableb.pk)

I can't figure how to implement the where not exists part of this. I
don't think the merge is doing the same thing as this.

Any ideas?

Thanks!

.

Relevant Pages

  • Dynamic PreparedStatements with Variable In Parameters
    ... AND col2=? ... AND col3=? ... I have to start coding tomorrow so I'm eager ...
    (comp.lang.java.programmer)
  • Re: Strange effects of Cast
    ... Cast to tuncate strings. ... In the query below although I get the expected result in COL1 and COL2 ... COL3 and COL4 return only three characters. ...
    (comp.databases.oracle.misc)
  • Re: How to check that the Cursor is on the last row?
    ... That is, in Erland's example no two rows have the same col1, same ... ORDER BY col1, col2 DESC, col3, PKcol ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • RE: DataValidation Check in cell of excel
    ... range where the Data Validation is, it is wiped out and anything can be ... when user enters in col1, it should be allowed only if data is not ... present in col2 and col3. ...
    (microsoft.public.excel.misc)
  • Re: store procedure or ...
    ... select colkey from tableA where col1 is null and col2 is null ... then get the result and put in loop, for each colkey put in a variable. ...
    (microsoft.public.sqlserver.programming)