I want to filter out records from a table which I will call Table A which has a date field named "Date Lost". The goal is to extract records from Table A with a Date Lost value that is less than a date value retrieved from Table B.
Table A has the following fields:
1) State
2) Property Type (with a value of either a)Cash b)MF or c) Stocks)
3) Date Lost
Table B has the following fields:
1) State plus Date fields for 2)Cash 3)MF 4)Stocks
The idea is to match the Property Type value from Table A (either Cash, MF or Stocks) against Table B's matching Date field and compare the date value record from Table B against the Date Lost value from Table A. Can this be done with just SQL ?
Table A has the following fields:
1) State
2) Property Type (with a value of either a)Cash b)MF or c) Stocks)
3) Date Lost
Table B has the following fields:
1) State plus Date fields for 2)Cash 3)MF 4)Stocks
The idea is to match the Property Type value from Table A (either Cash, MF or Stocks) against Table B's matching Date field and compare the date value record from Table B against the Date Lost value from Table A. Can this be done with just SQL ?