opc.three (1/2/2013)
Your request could be taken multiple ways, I think. If you have a moment to spare please post a table definition (CREATE TABLE statement), some sample data (INSERT statements), your expected results per that sample data and what you have tried so far and I will be happy to help you find a query that will return the rows you need.
Dear HOG
you have given us your query...great and thanks,,,,but we cant see what you can see.
I am sure that this can be resolved for you....but it will be much easier for us to help you if you can do as OPC suggested above .....that is please :
provide create table statements for your three tables that you refer to
provide some sample data as insert statements to populate these tables
and based on the sample data...what results (and the reason why) you are expecting.
kind regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day