I am working on a form with a grid that needs to display records if a value on the grid's datasource does not match a value on another table. I'm adding the second table as a datasource to the main datasource but am having a difficult time finding an example of using a range to only select records where a field from both datasources don't match. An example sql statement is below.
select * from tablea tbla
inner
join tableb tblb on tblb.field1 = tbla.field1 and tblb.field2 <> tbla.field2
I'm assuming that adding a datasource for tableb to tablea and the using addlink statements to join the two is the correct path but haven't figured out the addrange part.
Thanks for the help, Jim
*This post is locked for comments
I have the same question (0)
