[vicsireland] SQL and VBA - what fun
- From: "Sandberg, Robert" <robert.sandberg@xxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Thu, 1 Feb 2007 14:43:47 +0100
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
Other related posts: