OraFAQ Forum: SQL & PL/SQL » sql query advice/help

Home » SQL & PL/SQL » SQL & PL/SQL » sql query advice/help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql query advice/help [message #9066]

Thu, 16 October 2003 09:36

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 21 17:57:24 CDT 2025