Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> General SQL statement question
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
![]() |
![]() |