Hi List, My head is not on right today.
I have something like this: main_table id name main_type 1 joe type1 2 john type2 3 jack type1 table type1 id_type1 id action 1 1 2003-07-01 2 1 2003-08-03 3 2 2003-04-04 4 1 2003-09-09 I want to do a query to find all the names with an action date between a range of dates. For instance: The "logic" reads. I want the names, dates of the action and main_types of all the people who have an "action" entry in the type1 table between date1 and date2 (where date1 and date2 are user input for the search criteria). The result MUST contain duplicate names (if like for example Joe in the example above, has more than one "action" entry in the table that lies in the search date range.) Help? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]