Re: Calling stored procedures from other stored procedures. Possible?

[Roland Bouman]

I'm hearing two different things here - 1) joining tables 2) calling procedures.

To be clear on this - in MySQL, you cannot reuse the resultset returned from a stored procedure in the calling statement. I know you can in SQL Server, but you cant here. Period.

So, if you want to comine records from different tables, use join:

select *
from company c
inner join individual i
on c.companyid = i.companyid

If you want to call a stored procedure, use call:

call myproc();

Ok, now your requirements:

"If Individual is linked to company the Individual should be automatically be added to company record through Contact Stored procedure."

Correct me if im wrong, but i think that for a Individual to be "...linked to company.", the individual record would have a value in it;s companyid column that identifies a record in the company table, right? If that is so, why do you want to modify the company record? What do you mean by "..added to company record.."?

PLease provide (pseudo)code to illustrate your requirements.

Roland