MS Access 2000 SQL - Join 2 tables using BETWEEN

[KMITCH]

I would like to be able to join two tables using something
like 'Table1.Age BETWEEN Table2.MinAge and Table2.MaxAge'.
Is this possible in access?

Thanks,
Keith [sig][/sig]

 

[THoey]

Try this. Create a new query in design view. Go to SQL view and paste the following code in.

SELECT table1.Age
FROM table1, table2
WHERE table1.Age between table2.MinAge and table2.MaxAge;

Hope it helps...
[sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]

 

[KMITCH]

Thanks Terry! That was exactly what I needed.

Keith [sig][/sig]