Need Help with a Like Statement...

From: Kurt Harless <harless_at_ix.netcom.com>
Date: 1996/07/02
Message-ID: <31D9C40C.6A22_at_ix.netcom.com>#1/1


Have the following Select statement that joins one table to another via a like statement, then returns any rows from datax1.dsn that didn't have a matching pattern string in Pattern_Match.Pattern...

SELECT DISTINCTROW DATAX1.DSN
FROM DATAX1 LEFT JOIN Pattern_Match ON DATAX1.DSN like Pattern_Match.Pattern
WHERE (Pattern_Match.Pattern Is Null);

How would I do this in Oracle 7?

Thanks

Kurt Received on Tue Jul 02 1996 - 00:00:00 CEST

Original text of this message