can i use inner and outer join in some sort of cunjunction. Someone said they would be good to use when doing some dynmic reportiong yesterday and i have found they are but i just ran into a rodablock. <BR><BR>Because of the way the database is set up i have a list of all the actual events thus finding if someone is registered for one event it&#039;s just and inner join works fine for two events or three or whatver.<BR><BR>Same is true if i want to find people not going to events a b and c but...what should i do when i want to find people going to event A but not event B? this seems like it would be a combo of the two but i am not really sure how i would implement it<BR><BR>thanks<BR>andrew