Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> question on where clause

question on where clause

From: Jean Legare <jglegare_at_hotmail.com>
Date: 8 May 2004 13:18:20 -0700
Message-ID: <68e7005a.0405081218.bb39347@posting.google.com>


Hello:

I've come across a where clause that I haven't seen before.

Select

     table1.column1,
     table2.column2
from
     table1,
     table2
where
     1=1
   and
     table1.column3 = table2.column3

What puzzles me is the first line in the where clause, "1 = 1"

This is always true so why put it in? What purpose does is serve?

Thanks

J Received on Sat May 08 2004 - 15:18:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US