>Actually you have this statement. Second join can be incorporated into it easily but remember two simpler SQL-statements usually run faster than one complicated.
Thank you for your time and advice I will follow that age old rule:
KISS - Keep It Simple Stupid...
You are right sometimes with these new tools and faster computers
we look first for the complicated then see that simple solutions are better.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope