Hi,
I need a way to eliminate data from table A if it exists in table B. I need to combine these two tables but show their similar data only once..how can i do that?
Example:
Table B data:
john 10/11/2008 book
john 5/10/2008 novel
table A fields:
john 10/11/2008 book
Results that i need:
john 10/11/2008 book
john 5/10/2008 novel
No, i cannot only show table B's data because there might be data in table A that are not in table B.
I need a way to eliminate data from table A if it exists in table B. I need to combine these two tables but show their similar data only once..how can i do that?
Example:
Table B data:
john 10/11/2008 book
john 5/10/2008 novel
table A fields:
john 10/11/2008 book
Results that i need:
john 10/11/2008 book
john 5/10/2008 novel
No, i cannot only show table B's data because there might be data in table A that are not in table B.