Dear all, I'm having an 'end of the day' problem that I know is easy and I also know I have done before but can I remember the syntax? Can I ....
I want to join three tables with an SQL Select. Each table has a column in it that contains a reference number. What do I need to put in the 'Where clause' ? To join two tables the where clause is: Accident.reference = Casualty.reference Thanks all... Rgds, David ---------------------------------------------- David A. Eagle GIS Consultant Atkins Design Environment & Engineering Cornerstone House Stafford Park 13, Telford Shropshire, TF3 3AZ England Tel: +44 (0)1952 21 3268 * Fax: +44 (0)1952 20 0981 * Email: [EMAIL PROTECTED] * Web: www.atkinsglobal.com <www.atkinsglobal.com> * This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3629
