need help implementing the Union operator(SQL) in java

[varuna iyengar]

I need to implement the union operator for the union of two tables in java. I have checked for table compatibility(i.e. the attributes and the data types match correctly), but need to append the data tuples of the two individual tables into one table. Please let me know how to go about it.

Thanks

[Wouter Oet]

First of all welcome to the Java Ranch. What have you tried? And what kind of problems did you encounter?

[varuna iyengar]

Thanks. I'm actually using java to implement the Union operation of SQL. I have checked the two tables in question for compatibility i.e the attributes and their corresponding data types match completely. Now, I need to combine the data tuples of both these tables to one. Any in-built functions in java that could help me do it?

[Wouter Oet]

You just basically copied the content of your first post. Is your table a java class or do you mean a database table? In either case what have you tried to join them? Show some code. ShowSomeEffort

[Wouter Oet]

By the way: we have a name policy.

[Campbell Ritchie]

Moving to our databases forum where this sort of question is usually asked.

[varuna iyengar]

Sorry about the goof up about the display name. Also, I found a solution to my problem. Thanks anyways

[Campbell Ritchie]

And what was the solution? Others will benefit from knowing.