I have a table Concepts which has a relationship with a table StatementLines. They are connected like so:
Concepts.id_concept = StatementLines.idf_concept
Concepts.g_start_date <= StatementLines.line_date
Concepts.g_end_date >= StatementLines.line_date
where the g_start_date and g_end_date are global fields on Concepts.
I want to display Only those records from Concepts that have an associated corresponding record in StatementLines according to the relationship specified above.
Can you help?
It seems that this kind of problem must have come up many times to other programmers...