MySQL Forums
Forum List  »  Newbie

Hide rows in table1 based on same content in table2
Posted by: Smith Smith
Date: November 07, 2021 06:34AM

Hello,
I am using DB4S at the moment and have 4 columns of data in table1 :

Hex,col2,col3,col4

I import csv data daily which often contains duplicate row data that I've already processed from a previous date.

If I create a table2 with a single column and add the Hex value of the rows that I've already processed in table1, is there some SQL I could run which would hide any matching hex values found in table1?

Thanks for any help.
Rgds.
Rob

Options: ReplyQuote


Subject
Written By
Posted
Hide rows in table1 based on same content in table2
November 07, 2021 06:34AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.