Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

Need assistance w/ SQL query

Name: Anonymous 2006-05-31 8:55

Using Jet-SQL (I know, flame away, as long as someone tries to help), have a table of people. One field contains their birthdate, and given user input of a pair of dates (one "low", one "high")I need to use this field to figure out who will be turning exactly X yrs old at a time between the user's given high and low dates. Any help appreciated. And while I do intend to eventually switch database solutions, until I have the spare hardware and time to implement, that is not something I can do immediately.

Name: Anonymous 2006-05-31 9:14

What's the INNER JOIN for? Could that be anything to do with it, as it will restrict the rows returned from tblEMP to those with a LOC_NUM in tblinslocmast.

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List