This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes ---= sql String =--- Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "---= sql String =---" Watch "---= sql String =---" New topic
Author

---= sql String =---

du sixiang
Greenhorn

Joined: Mar 10, 2003
Posts: 3
why the sql String "select u.user_name,u.user_id from db_users u ,db_orders o where
u.user_id=o.ore" can search what i want,but the
String "select u.user_name,u.user_id from db_users u ,db_orders o,db_vip_users v where
u.user_id=o.ore" show me "no rows"?
Ren Bia
Greenhorn

Joined: Mar 11, 2003
Posts: 1
Because your select result part of your sql contains no columns of the table v and your where part of the sql also have no connect string of the table v and u/o!
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: ---= sql String =---
 
Similar Threads
First run on Firebird. Some good but then crashes. Help needed please.
DB Differences??
SQL error, generic_queries.sql 1.105
SQL Help Please
About send e-mail