<div>
Condition for SQL UNION is that &nbsp;tables must match number and names of columns. You are using &quot;select *&quot; for each one, then, Table B is exactly similar than Table A?
</div>


Condition for SQL UNION is that  tables must match number and names of columns. You are using "select *" for each one, then, Table B is exactly similar than Table A?

<div>
I am using the query as below per result is same as above -<br />
<br />
String sqlString = Select Employee_ID , Employee_Code &nbsp;from A union Select Employee_ID,Employee_Code &nbsp;from B<br />
<br />
its giving null when i am executing below -<br />
<br />
result = stat.executeQuery(sqlStrin<wbr />g);<br />
<br />
But if I am running individually one by one its giving result . please let &nbsp;me know where i am wrong.
</div>


I am using the query as below per result is same as above -

String sqlString = Select Employee_ID , Employee_Code  from A union Select Employee_ID,Employee_Code  from B

its giving null when i am executing below -

result = stat.executeQuery(sqlString);

But if I am running individually one by one its giving result . please let  me know where i am wrong.

<div>
You shouldn't have problems. Could you put more detail of the java code?
</div>


You shouldn't have problems. Could you put more detail of the java code?

<div>
<div class="content wysiwyg-content">
HI Team ,<br />
<br />
I am retrieving value from database through JDBC statement &nbsp;my plsql query is below -<br />
<br />
Select * from A union Select * from B.<br />
<br />
but when i am retrieving value through JDBC statements its give null . when i am individually running query like Select * from A without using Union &nbsp;its working fine and giving results but when i am using 2 query via Union its give Null. Please tell me where i m wrong .
</div>
</div>


HI Team ,

I am retrieving value from database through JDBC statement  my plsql query is below -

Select * from A union Select * from B.

but when i am retrieving value through JDBC statements its give null . when i am individually running query like Select * from A without using Union  its working fine and giving results but when i am using 2 query via Union its give Null. Please tell me where i m wrong .

Retrieve value from database through JDBC statement.

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

PL/SQL

Java Enterprise Edition (Java EE) is a specification defining a collection of Java-based server and client technologies and how they interoperate. Java EE specifies server and client architectures and uses profiles to define technology sets targeted at specific classes of applications. All Java EE profiles share a set of common features, such as naming and resource injection, packaging rules and security requirements.

Java EE

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.