SQLite Select single colum where two tables match -

SQLite Select single colum where two tables match -

hi want entries of single colum of 1 table 2 colums of 2 tables match (like join).

so far sucessfully extract columns of both tables where statement:

select * table1, table2 table1.ab_id=table2.ab_id

but when want select single column not working:

select colx table1 table1.ab_id=table2.ab_id

probably rather simple problem...

i think need utilize join:

select table1.colx table1 inner bring together table2 on table1.ab_id=table2.ab_id;

sqlite select where