Home -> Usenet -> comp.databases.oracle -> SQL statement

SQL statement

From: Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
Date: Tue, 30 Oct 2001 22:49:58 +0100
Message-ID: <9rn7uo$57b9$4_at_as201.hinet.hr> 






    
  
  1.   I have two tables: tableA,tableB
  
  2.   tableA has columns: colA1,colA2; tableB has columns: colB1,colB2
  
  3.   realtion tableA.colA1=tableB.ColB1






I want to set colA2 to zero of every row if i.e. it's corresponding
colB2 begins with letter 'A'



What is the SQL statement?


--

Stjepan Brbot [Stjepan.Brbot_at_ZG.HiNet.HR]


Received on Tue Oct 30 2001 - 22:49:58 CET












Original text of this message