derby search by join date

Question

derby search by join date

Navigation

#1 by (1 votes)

2

I must select the names of the clients whose service was made on 2012-07-15

SELECT nombre FROM Clientes c JOIN Servicios s WHERE s.Fecha = '2012-07-15';

but I get an error

[Exception, Error code 30,000, SQLState 42X01] Syntax error: Encountered "WHERE" at line 1, column 48.

sql derby

asked by ives rodriguez 31.10.2017 в 20:41

source

1 answer

Error in debug \ AndroidManifest.xml ExecutionException: java.util.concurrent.ExecutionException: com.android.tools.aapt2.Aapt2Exception: AAPT2 error How to integrate 'swipe' from Hammer.js in Backbone?

score 1 · Answer 1

You lack the join condition using the ON clause. I do not have the details of your columns, but you may have a ClientId column in both tables, or something like that. In that case, the query would be something like:

select nombre
  from Clientes c
  join Servicios s
    on s.ClientId = c.ClientId -- te falta esto
 where s,Fecha = '2012-07-15';