Question about relational delete query

[ja]

Hello,

I am new to ms access. I am trying to do a relational delete query.
Here is what I would do in ms sql:

delete t1
from t1, t2
where t1.f1 = t2.f1

I've been trying to to do it in ms access 2002 using the wizard,
desing and sql modes. I can't figure out what ms is requesting me to
do.

Would you help me?

tia

ja

[Steve Jorgensen]

On Tue, 24 May 2005 18:49:19 GMT, ja <yo*@me.net> wrote:

Hello,

I am new to ms access. I am trying to do a relational delete query.
Here is what I would do in ms sql:

delete t1
from t1, t2
where t1.f1 = t2.f1

I've been trying to to do it in ms access 2002 using the wizard,
desing and sql modes. I can't figure out what ms is requesting me to
do.

Would you help me?

I think what you need is...

DELETE t1.*
FROM t1
INNER JOIN t2
ON t1.f1 = t2.f1

[MacDermott]

I've had better luck doing it this way:

DELETE t1.*
FROM t1
WHERE t1.f1 IN (SELECT DISTINCT t2.f2 FROM t2)
"ja" <yo*@me.net> wrote in message
news:bn********************************@4ax.com...

Hello,

I am new to ms access. I am trying to do a relational delete query.
Here is what I would do in ms sql:

delete t1
from t1, t2
where t1.f1 = t2.f1

I've been trying to to do it in ms access 2002 using the wizard,
desing and sql modes. I can't figure out what ms is requesting me to
do.

Would you help me?

tia

ja