Home » SQL & PL/SQL » SQL & PL/SQL » sql query advice/help
sql query advice/help [message #9066] Thu, 16 October 2003 09:36 Go to next message
atom palmer
Messages: 1
Registered: October 2003
Junior Member
Hello,

I am a entry level SQL user and could use a little help with a query.

I have 2 tables (tableX and tableY)
there is one common field (fieldA)

fieldA is a code for the first 12 digits of an account number
let's call that fieldB

what query do i need to run to get a fieldB entry of tableY for every time fieldA has an entry in tableX?

thank you very much
ap
Re: sql query advice/help [message #9076 is a reply to message #9066] Thu, 16 October 2003 13:08 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Select Y.FieldB
  From Y
     , X
 Where X.FieldA = Y.FieldA
MHE
Previous Topic: random %
Next Topic: Updating 70K records taking 5 hours
Goto Forum:
  


Current Time: Thu Mar 28 16:31:42 CDT 2024