I have two tables: t1 (main table), t2 (related table).
I should show on form only t1 and t2 records, where for t1 related t2 records exist,
Normaly I could use InnerJoin, but I have two grids: t1, t2.
- InnerJoin shows the same count of resords for t1, how much records exists for t2.
- OuterJoin return all t1 records, even related records not exist in t2
- ExistJoin return correct redords for t1, but records without values for t2.
Is here some solution?