Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

need help implementing the Union operator(SQL) in java

 
varuna iyengar
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Saloon Keeper
Posts: 2700
IntelliJ IDE Opera
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First of all welcome to the Java Ranch. What have you tried? And what kind of problems did you encounter?
 
varuna iyengar
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Saloon Keeper
Posts: 2700
IntelliJ IDE Opera
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Saloon Keeper
Posts: 2700
IntelliJ IDE Opera
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
By the way: we have a name policy.
 
Campbell Ritchie
Sheriff
Posts: 51407
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to our databases forum where this sort of question is usually asked.
 
varuna iyengar
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry about the goof up about the display name. Also, I found a solution to my problem. Thanks anyways
 
Campbell Ritchie
Sheriff
Posts: 51407
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And what was the solution? Others will benefit from knowing.
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic