mardi 12 janvier 2016

Comparing two values on sqllite from diferent table

im trying to make a where clause from a diferent table with 2 values in match for example on sqllite

Date|CID|text
1/1/90 22:22:22 1 hi
1/1/90 21:22:30 1 How are you
1/1/90 03:22:22 3 hey 

table 2

ID|date|CID|text
100 1/1/89 11:22:11 1 hello
200 1/1/90 22:22:22 1 hi
300 1/1/90 21:22:30 1 How are you
400 1/1/90 03:22:22 3 hey
500 1/1/85 02:22:22 3 hey
600 1/1/90 03:22:22 80 hey

how to make the query give me the ID from table 2 matching CID and date from table 1
Note:If i use where IN the result if some date match in the case of ID 600 and 400 the result will be on the query and im not looking that.

just matching CID and Date from the table 1 should list the result.

Thanks.

Aucun commentaire:

Enregistrer un commentaire