Foxpro question

I am trying to join two tables in foxpro, but I have to write the program to make the key in one table to be "less than" one number and "greater than" another number in a second table. this should be a left join. anyone knows whether this is possible and how to make it work? Thanks a lot!!!!!!!!