mardi 16 juin 2015

How to select columns in a table with have values not nul in an other table

I have two sql tables ( i am using sqlite).

Table1 (code TEXT)
Table2 (code TEXT, codeTable1 TEXT)

How i can please fetch all the table1's content witch has at least one row in the table 2 with the codeTable1 not null ?

Aucun commentaire:

Enregistrer un commentaire