I have two tables in two different schemas. I have to join these two tables and fetch the record in java. maria DB does not support functions, so i can't use functions. Anyone is having any thought on this ?
Asked
Active
Viewed 52 times
0
-
Can you add the code to your question? – codeforester Jan 30 '17 at 18:32
-
@codeforester Sorry, I can't share code as it is very confidential. I have 2 tables in two different schemas and i need to fetch record from both the tables in a single query. – Barun Jan 31 '17 at 03:31
-
this may help http://stackoverflow.com/questions/27377431/how-to-create-multiple-schema-connections-using-java – Sasikumar Murugesan Jan 31 '17 at 12:44
1 Answers
0
select t.field1, t2.field1
from schema1.tablename t,
schema2.tablename t2
where t.key = t2.key;
Marco Polo
- 728
- 5
- 10