Joins

[gandhids]

Hi,
I have go two tables...A and B
Table A has
Investment_id as primary id,while Table has following structure.
Deal_id,Property_id,Investment_id,detail_id,month and year.Table A stores the data for current month while table B stores data for all past months.Now in my report, i have to show those Investments_id which are there in table A but not there in Table B for a particular(the value that i will be passing thru prompt) month and year.I should be able to pass these month and year values thru prompts.Note that a particular A.investment_id can be there in Table B for not prompt-passed month and year.

 

[bcking]

I'd probably tackle this using a filter, just make sure that you have an outer join on A and filter where B.investment_id is missing.

Hope this helps.
Brett