![]() |
How to filter out unwanted data
I have the following fields in table A:
Code:
Date | Descrip | Amt Dr Code:
Date | Descrip | Amt Dr What i want is to extract the date,descrip & Amt data from Table A where it's Descrip data is not the same as the data in Table B's Descrip column. My sql syntax is as follows: Code: SQL
Code:
Date | Descrip | Amt Dr is what the sql should filter out, but failed to do so, what i want is as below: Code:
Date | Descrip | Amt Dr |
Re: How to filter out unwanted data
Why do you need the group by clause the row that is coming unwanted check if there is any traling spaces in any of the tables because those record that are equal in both table should not be coming according to the Where clause.
|
| All times are GMT +5.5. The time now is 09:21. |