y, November 06, 2003 1:43 PM
Subject: Re: How to get two columns from different tables
You're almost there in how you worded your quesiton.
You'll need a join.
select tab1.test1, tab2.test1 from tab1 inner join tab2 on tab1.id =
tab2.id. --> this will get all columns where hte ids
lt;[EMAIL PROTECTED]>
rfam.pl> cc:
Subject: How to get two columns from
different tables
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 do
