Help writing database queries for derby?

Posted by outsyncof on Stack Overflow See other posts from Stack Overflow or by outsyncof
Published on 2010-03-12T02:30:42Z Indexed on 2010/03/12 2:37 UTC
Read the original article Hit count: 395

Filed under:

database-queries

|

derby

I have a database containing multiple tables (Person, Parents, etc)

Person table has certain attributes particularly ssn, countryofbirth and currentcountry.

Parents table has ssn, and fathersbirthcountry

I'm trying to output the SSNs of all people who have the same countryofbirth as their fathersbirthcountry and also have same currentcountry as fathersbirthcountry.

SELECT Person.ssn 
FROM Person, Parents 
WHERE fathersbirthcountry = countryofbirth 
AND currentcountry = fathersbirthcountry;

the above doesn't seem to be working, could anyone please help me out?

© Stack Overflow or respective owner

Related posts about database-queries

Help writing database queries for derby?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database containing multiple tables (Person, Parents, etc) Person table has certain attributes particularly ssn, countryofbirth and currentcountry. Parents table has ssn, and fathersbirthcountry I'm trying to output the SSNs of all people who have the same countryofbirth as their fathersbirthcountry… >>> More
SQL SERVER – Spatial Database Queries – What About BLOB – T-SQL Tuesday #006

as seen on SQL Authority - Search for 'SQL Authority'
Michael Coles is one of the most interesting book authors I have ever met. He has a flair of writing complex stuff in a simple language. There are a very few people like that. I really enjoyed reading his recent book, Expert SQL Server 2008 Encryption. I strongly suggest taking a look at it. This… >>> More
SQL SERVER Spatial Database Queries What About BLOB T-SQL Tuesday #006

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Michael Coles is one of the most interesting book authors I have ever met. He has a flair of writing complex stuff in a simple language. There are a very few people like that. I really enjoyed reading his recent book, Expert SQL Server 2008 Encryption. I strongly suggest taking a look at it. This… >>> More
MS Access split database queries

as seen on Super User - Search for 'Super User'
When the frontend of a MS Access db queries a MS Access backend on another machine over the network, does it pull in the whole table/database/file, or does it have some way of extracting just what it needs from the backend, thereby lessening network load. >>> More
How to keep character encoding with database queries.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am doing the following. 1) I am exporting a database and saving it to a file called dump.sql. 2) The file is then transferred to a different server via PHP ftp. 3) When the file has been successfully transferred the administrator has an option to run a 'dbtransfer' script on the new host. 4)… >>> More

Related posts about derby

Apache Derby running in Tomcat shutdown issues

as seen on Server Fault - Search for 'Server Fault'
I have set up Derby Network Server to be hosted within a Tomcat environment. This works great. However, when I shut down Tomcat I get the following errors: 04/01/2011 10:41:41 AM org.apache.catalina.core.StandardService stop INFO: Stopping service Catalina 04/01/2011 10:41:41 AM org.apache.catalina… >>> More
Apache Derby running within Tomcat causes shutdown issues

as seen on Server Fault - Search for 'Server Fault'
I have set up Derby Network Server to be hosted within a Tomcat environment. This works great. However, when I shut down Tomcat I get the following errors: 04/01/2011 10:41:41 AM org.apache.catalina.core.StandardService stop INFO: Stopping service Catalina 04/01/2011 10:41:41 AM org.apache.catalina… >>> More
Derby vs PostgreSql Performance Comparison

as seen on Stack Overflow - Search for 'Stack Overflow'
We are doing research right now on whether to switch our postgresql db to an embedded Derby db. Both would be using glassfish 3 for our data layer. Anybody have any opinions or knowledge that could help us decide? Thanks! edit: we are writing some performance tests ourselves right now. Looking for… >>> More
How to format a date using Apache Derby?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I would like to format nicely a date received from a query like: SELECT recdate FROM myrecords; pratically I am searching the function to pretty formatting with a date pattern, better if SimpleDateFormat like. And if not possible how can I build a class for formatting with somtehing like: SELECT… >>> More
Apache Derby supports natively script delimiters?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I know that I could separate all statements by pre-cutting before their execution, but I have a case in which I would like to insert a series of statements in one execution, currently I receive the following error: Caused by: java.sql.SQLException: Syntax Error: Encountered ";" at line 2,… >>> More