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

Home -> Community -> Usenet -> c.d.o.misc -> General SQL statement question

General SQL statement question

From: <dutilr_at_netscape.net>
Date: 16 May 2005 07:37:21 -0700
Message-ID: <1116254241.232353.211420@g49g2000cwa.googlegroups.com>


You'll have to excuse me, but I'm a little light on my SQL skills. Can anyone tell me if the following SQL query should work or not? It has 4 files, but the first file isn't linked to any of the other three files in the WHERE clause. I don't get it. Am I just missing something? Please let me know if you have any thoughts or suggestions.

insert into cs02p10w
SELECT DISTINCT a.csnwpl,d.opcatn,d.oppric FROM cs01p10w a, opprltp d,mspmj200 e, cs03p100 g WHERE d.opplst=&PL
  and d.opcatn=e.prdno
  and integer('0'||e.uprgrp)=g.cspgrp
  and d.oppric<>0
  and (substr(e.ubusut,1,1) between 'A' and 'H' or e.ubusut like 'M%' )   and e.ubusut||e.ufamly<>'M O ' with NC Received on Mon May 16 2005 - 09:37:21 CDT

Original text of this message

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