Oracle Db Or Sql Developers Plz Help Is Writing A Sub-Query -

[jersey babai]

I have a Oracel db with many tables.

In 1 table there are nearly 50,000 users with respective 'user numbers' and with respective 'manager names' in 2 different columns.

In another table 'user numbers' of managers 'manager names' vunnayi.



Naku oka 1150 'user numbers' list

SO, oka querry run chetshey


that 1150 'users numbers' and respective manager user numbers' result ravali.


ela ?


Hope I didn't confused you.

[jersey babai]

Konchem urgetn mama, evarin telisthey cheppandi plzzz

[jersey babai]

Manual ga cheyyali antey atleast 2 days padatadi

[Bairagi From Bapatla]

manager names meedha join chesthe vasthundi anukunta....

[latelugodu]

Try this...

select t1.user_num, t2.mgr_num from table1 t1, table2 t2
where t1.manager_name = t2.manager_name
and rownum < 1151

Not sure if I understood your question correctly though

[jersey babai]

[quote name='Bairagi From Bapatla' timestamp='1354219538' post='1302873174']
manager names meedha join chesthe vasthundi anukunta....
[/quote]


Artham kaaledu baa,

Queeriesa salu hava ledu naku.


[b]Select

USER_NUMBERS, MANAGER_NAMES


From USER_REPOSIROTY

Where[/b]

[b]USER_NUMBERS= ''[/b]

[jersey babai]

[quote name='latelugodu' timestamp='1354219862' post='1302873216']
Try this...

select t1.user_num, t2.mgr_num from table1 t1, table2 t2
where t1.manager_name = t2.manager_name
and rownum < 1151

Not sure if I understood your question correctly though
[/quote]



I need clomuns 1 info and columns 2 info from 2 different tables baa for 1152 users.

[jersey babai]

[quote name='BABUU' timestamp='1354219893' post='1302873221']


Artham kaaledu baa,

Queeriesa salu hava ledu naku.


[b]Select

USER_NUMBERS, MANAGER_NAMES


From USER_REPOSIROTY

Where[/b]

[b]USER_NUMBERS= ''[/b]
[/quote]


but, MANAGER_NUMBER verey table lo vundi, adi ela testhamu ?

[latelugodu]

oh.. you have the 1152 users somewhere? a list or another table?