Calling stored Procedure from one db to give me a result in another db CREATE DEFINER=root@localhost
PROCEDURE AccountReqs( IN IsNewAccountStart VARCHAR (255)
                 , In AccountName varchar (255)
                 , IN AccountNumber varchar(255)
                 , In PaymentTerm varchar(255)
                 , IN Batch varchar (255)
                 , In AdditionalEmailAddresses varchar (500)
                 , In WorkEmail varchar(500)
                 , In PersonalEmail varchar (500) )`
BEGIN
    SELECT * FROM ACCOUNTS
    WHERE IsNewAccountStart &lt;&gt;'TRUE' AND IsNewAccountStart &lt;&gt;' ' 
    Union all 
    SELECT * FROM ACCOUNTS WHERE AccountName=' ' 
    Union all 
    SELECT * FROM ACCOUNTS WHERE AccountNumber=' ' 
    Union all 
    SELECT * FROM ACCOUNTS 
    WHERE PaymentTerm &lt;&gt; 'Net 30' 
    AND PaymentTerm &lt;&gt; 'Net 45' 
    AND PaymentTerm &lt;&gt; 'Net 60' 
    AND PaymentTerm&lt;&gt; 'Due Upon Receipt' 
    Union All 
    SELECT * FROM ACCOUNTS WHERE Batch &lt;&gt; 'Batch1';

    SELECT * FROM ACCOUNTS
    WHERE AdditionalEmailAddresses &lt;&gt; ' '
    OR WorkEmail &lt;&gt; ' '
    OR PersonalEmail &lt;&gt; ' ';

END
SUGGESTION #1

You need to explicitly set the database before calling the Stored Procedure

USE targetDB
CALL Shared.AccountReqs(...);


SUGGESTION #2 (OPTIONAL)

Since you have all these UNION clauses against the same table, try combining all the WHERE clauses under a single SELECT. I see two SELECTs in your original question. Therefore, the Stored Procedure should look more like this:

CREATE DEFINER=`root`@`localhost` PROCEDURE `AccountReqs`(
  IN IsNewAccountStart VARCHAR (255),
  In AccountName varchar (255),
  IN AccountNumber varchar(255),
  In PaymentTerm varchar(255),
  IN Batch varchar (255),
  In AdditionalEmailAddresses varchar (500),
  In WorkEmail varchar(500),
  In PersonalEmail varchar (500)
)
BEGIN
    SELECT * FROM ACCOUNTS 
    WHERE (IsNewAccountStart &lt;&gt;'TRUE' AND IsNewAccountStart &lt;&gt;' ')
    OR    (AccountName=' ') OR (AccountNumber=' ')
    OR    (PaymentTerm NOT IN ('Net 30','Net 45','Net 60','Due Upon Receipt'))
    OR    Batch&lt;&gt; 'Batch1';

    SELECT * FROM ACCOUNTS
    where AdditionalEmailAddresses&lt;&gt;' '
    Or  WorkEmail&lt;&gt; ' '
    Or  PersonalEmail&lt;&gt; ' ';
END