merging two data streams

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC 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: 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)
  • Re: slecting multiple distinct columns..
    ... this will bring back records that have duplicate records ... Col1, Col2, Col3, COUNTas NumberDups ...
    (comp.databases.ms-sqlserver)