Posted by mariohiga on 02/15/06 00:09

Hello
I've a really big doubt :) I've this two alternatives

SELECT *
FROM T1 a
INNER JOIN T1 b
ON a.F1 = b.F1
AND a.F2 = 1

SELECT *
FROM T1 a
INNER JOIN T1 b
ON a.F1 = b.F1
WHERE a.F2 = 1

I don't know when I've use a.F2 = 1
1) In the INNER JOIN statement OR
2) In the WHERE condition

I appreciate any idea
Thanks a lot

• Next in forum: Re: Capturing Mysterious Truncation/deletion of a table
• Prev in forum: Query Help!
• Thread view: About Join OR Where

[Reply to this message]