[sqlite] Table alias in sqlite

[Anirban Sarkar]

Hi all,

Please refer to the sqlite query below:

set connection_no { }

set stmt "select m.*, h.* from mri m,hp_con h where m.rdg_flg = '0' and
h.hp_id = $hp_no and m.con_no = h.con_no order by m.con_no;"

db1 eval $stmt {} {

lappend connection_no $con_no
.f.l insert end $con_no

}

I have used two aliases for the two tables, m and h respectively. My problem
is how do I access the field con_no in the mri table. What should be the
syntax? The portion of the code where this is required is highlighted in
red.

Any early help will be highly appreciated.

Regards,
Anirban Sarkar