Hello, I`m a newer reader. I have problem with query. There are two tables:
tab1: id | test1 ------------ 0 | string1 1 | string2 2 | string3 and tab2: id | test1 ------------ 0 | string1 1 | string2 2 | string3 I want to get columns test1 (from tab1) and test2 where id.tab1 = id.tab2 but i don`t know how compare this expresion to constant i.e. id.tab1 = id.tab2 = 40 Haw Can I do this ? Regards