> After that, the SQL queries are essentially the same. > Not a big transition between any of them. the odd man out here is mysql, which doesn't do subselects or unions and ms access has its own set of functions, e.g. IIF instead of CASE for syntax differences, see this site -- A Gentle introduction to SQL http://www.dcs.napier.ac.uk/~andrew/gisq/ i have a ton of sql links, some of which i have started to post on my site (categorization is on my todo list) -- SQL Links http://r937.com/links.cfm?links=sql rudy http://rudy.ca/