I have a table which is a Master to other 12 tables and it is Child for
other 2 tables.
Therefore, It has 14 relationships with other tables. The size of table is
very small. (approx 30-40 rows). It also has a clustered index in its primary

How can I retrive data from a table in MS Access database within a
specified range of date?

I am a bit of a newbie to SQL Queries and need some help with the following
query.
I have two tables in SQL 2000 which hold info about user and roles.
In the first table I have a set of user info containing the user name and

i have a model column and has all sort of names.
E.g.
Model names
CRUZERCROSSFIRE00512

Is there an easy way to set a default value for values in unmatched rows
that return null
I wouldlike to return 0 for fields that return null in a left join

Is it possible to create a query that returns a count of each
application_request_detail_status_type_id as columns?
Any help on this would be greatly appreciated, thanks :)