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

Report message to a moderator

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

Report message to a moderator

Previous Topic: random %
Next Topic: Updating 70K records taking 5 hours
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 17 08:42:14 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.