Hi Thank you for reading my post. Imagine that we have a master details relation between two tables (using foreign Key) , now when we select some records from master table ,does JDBC retrive each record childs automatically ? can it be configured to do this ?
Q. I have a SQL (the language) question where should I ask it?
There are a vast number of SQL references, primers and tutorials available on the internet. It is recommended that you use Google to find an appropriate syntax guide for your database because databases do tend to have their own specific SQL dialects and what works on one system may not work on another.
For general SQL guidance the Wikipedia SQL reference is useful and may be found at http://en.wikipedia.org/wiki/SQL In the main article there are links to the various statements for a generic look at the purpose and syntax of these statements.
Was this wrong? Personally I don't think so. I mean if one wants to ask a SQL question go right ahead. But if the answer can be found elsewhere without waiting for someone to answer that makes sense to me.
Maximilian, I agree that people should feel comfortable using web sources rather than sit around and wait for an answer. But that's equally true for JDBC and Java questions. For SQL questions that aree conducive to a human being, this forum (JDBC) is the place to be. It even says so in the forum description: "Database access, JDBC/ODBC, could even brush on some SQL"
Common questions are "how can I make this query faster" or "how do I do ______ in SQL." More greenhorn like questions such as "I don't understand when to use a join" are welcome too.
I changed that passage in the wiki to read "Where can I get more information on SQL (the language)?" as I think that better reflects the intent of this forum.
If you want to discuss this topic anymore, I recommend starting a thread in the JavaRanch forum. That way we don't get too off topic from the master details relation