Re: SQL statment ???

From: Allen Kirby <akirby_at_att.com>
Date: 1997/06/02
Message-ID: <3392D7B8.2A77@att.com>#1/1

Chan Jeon Jeon wrote:

> TABLE1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=
 =A1=A1=A1=A1=A1=A1
> =A1=A1=A1=A1=A1=A1 COL1=A1=A1
> =A1=A1--------
> =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1 1
> =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1 2
> =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1 3
> =
 

> TABLE2
> =A1=A1COL2
> --------
> =A1=A1=A1=A1=A1=A1=A1=A1 4
> =A1=A1=A1=A1=A1=A1=A1=A1 5
> =A1=A1=A1=A1=A1=A1=A1=A1 6
> 2)=A1=A1I want to look the result
> =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=

=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=
=A1=A1

> COL1=A1=A1 COL2
> -----=A1=A1 ----
> 1=A1=A1=A1=A1 =A1=A1=A1=A1 4
> 2=A1=A1=A1=A1 =A1=A1=A1=A1 5
> 3=A1=A1=A1=A1 =A1=A1=A1=A1 6
> =
 

> 3) I don't know query statement.
> =A1=A1 Please help me .
> =
 

> Email : cjjeon_at_fkl.fujitsu.co.kr=A1=A1=A1=A1=A1=A1
> =A1=A1THANK YOU VERY MUCH.
This isn't logical. What logically links the '1' from table 1 and the '4' from table 2? You need a common field, usually another column, that you can use to join the two tables. e.g.

id col1
--- ----

1	1
2	2
3	3

id	col2
---	----
1	4
2	5
3	6

Then, you can do: =

select col1, col2 from table1, table2
where table1.id =3D table2.id;

• =

---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.

Received on Mon Jun 02 1997 - 00:00:00 CDT