subselects or join?

[Petre Agenbag]

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/my***********...ie.nctu.edu.tw