Hi everyone,

Could some one help me write the following SQL query, once I see the
basics I will be on my way.

I have 3 tables set up as such

Table A <<<>>> Table B<<< >>> Table C

Table B is the detail Table of A where Table A is the master table

Table C is the detail Table of B where Table B is the master table

ie all 3 tables are related

I need to find all records in Table A where the record in Table C = a value

TIA

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results