Unanswered: relation between two schemas in mysql using foreign key reference
I have two schemas A and B. In schema A i have a1 table and in schema B i have b1 table. the problem is i want to create a new table in B table b2.
In b2 a1 primary key is as foreign key and b1 primary key is as foreign key.
Can anyone please help me to solve this problem with out importing the table in to schema B.