[vicsireland] Re: SQL and VBA - what fun
- From: "Tony Murray" <Tony.G.Murray@xxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Thu, 1 Feb 2007 14:12:31 -0000
Hey Robbie,
Looks pretty standard to me, and it parses ok in SQL Server 2000's query
analyser.
What error is being thrown?
On another point entirely, if those table names and field names are not
aliases... I'd suggest revisiting your naming conventions though!;)
Take it easy,
Tony
----- Original Message -----
From: "Sandberg, Robert" <robert.sandberg@xxxxxxx>
To: <vicsireland@xxxxxxxxxxxxx>
Sent: Thursday, February 01, 2007 1:43 PM
Subject: [vicsireland] SQL and VBA - what fun
Hi folks!
Below is a simple SQL query, which I want to trigger in a VBA module.
I'm only familiar with the syntax used in Office 97. Something must have
been changed because I can't get it to work in Office 2003. Can anyone
enlighten me?
INSERT INTO t3 ( f1, f2, f3 )
SELECT t1.f1, t1.f2, t1.f3
FROM t1 INNER JOIN t2 ON (t1.f3 = t2.f3) AND (t1.f2 = t2.f2) AND (t1.f1
=
t2.f1);
Cheers,
Robbie
******************************************************
This document is strictly confidential and is intended for use by the addressee
unless otherwise indicated.
This email has been scanned by an external email security system.
Allied Irish Banks
******************************************************
Other related posts: