create a stored procedure from two datbases

Question

Post reply

create a stored procedure from two datbases

Anurag-428305

SSC-Addicted

Points: 489
More actions
April 12, 2007 at 2:21 am

#172974

)---We Have 2 Databases:
Say Db1 & Db2.
2)--Db1:-----
Tables:----
T1-Empno, Ename, Age
T2-Empno, Ename, Fathername
T3-Empno, salary,pf
3)--Db2:------
Tables:----
T1--Empno, DOJ, DOL
T2-Empno,Exp
4)--we have 3 input parameter---Ename, Age, DOJ
5)--Create a procedure which select Empno, Ename,Fathername,Age,Exp,DOJ,CTC(Salary+PF)
Pleas help me ........

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Adrian Nichols-360275 SSCertifiable Points: 7694 More actions · Answer 1

A simple JOIN (as you would with two tables from the same database) adding the database and owner to the qualifier.

The qualifier should look like this database.owner.table

Ade

A Freudian Slip is when you say one thing and mean your mother.
For detail-enriched answers, ask detail-enriched questions...[/url]

Anurag-428305 SSC-Addicted Points: 489 More actions · Answer 2

Nobody can reply this question????????

Strange.....................!!!!!!!!

Anurag-428305 SSC-Addicted Points: 489 More actions · Answer 3

Dear Adrian Nichols,

This question is asked in a MNC.So write me the solution of this question if u can.........

Adrian Nichols-360275 SSCertifiable Points: 7694 More actions · Answer 4

If it's a question asked of you then surely you should be coming up with the answer and not attempting to pass off someone else's work as your own???

Ade

A Freudian Slip is when you say one thing and mean your mother.
For detail-enriched answers, ask detail-enriched questions...[/url]

Anurag-428305 SSC-Addicted Points: 489 More actions · Answer 5

Dear Adrian Nichols

There is one Statement in our India, " G*** me nahi hai guda to lanka main kyon kuda". So Tension nahi lene ka, Mamu.

Anurag

Adrian Nichols-360275 SSCertifiable Points: 7694 More actions · Answer 6

Although my Hindi/Indonesian (haven't decided which it is yet, probably the former) is rusty, I believe that your reply involves originating from the loins of a horse and that I am a recipient of something (I've taken a guess).

I prefer to think that the translation is:

Yes, I completely agree, I should not be so lazy as to lower myself to plagiarism. Please forgive me, I will try harder next time.

But I doubt it.

Ade

A Freudian Slip is when you say one thing and mean your mother.
For detail-enriched answers, ask detail-enriched questions...[/url]