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