This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes query Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "query" Watch "query" New topic
Author

query

vamshi g
Greenhorn

Joined: Sep 12, 2008
Posts: 26
hi am having two tables in that i want check if the data exist or not in table1 column,if not retrieve the column value from table2,
please reply urgent for me,
thanks.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

If what data exists? Can you please TellTheDetails. Are you looking for a SQL only way of doing this, or is this JDBC code?
[ September 18, 2008: Message edited by: Paul Sturrock ]

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
vamshi g
Greenhorn

Joined: Sep 12, 2008
Posts: 26
in table1 if column data is null then retrieve from table2, i want query for this,thank you.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"vamshi vamshi",
Please check your private messages.
-DOM
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

vamshi, please check your private messages again.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: query
 
Similar Threads
HTML table - net value print
First Group by one column and then by sorting by another column
@Generatedvalue and MySQL
sql
HSSF identifying hidden excel column