On Wed, Feb 14, 2001 at 05:49:01PM +0300, Mikhail V. Majorov wrote:
> Hi, question
>
> How can I multiply tables using SELECT?
>
> Table 1
>
> id surname
> --------------
> 1 AAA
>
> Table 2
>
> dt
> ---
> 12
>
> RESULT
>
> id surname dt
> ---------------------------
> 1 AAA 12
I think what you want is the following:
table1:
id surename
===========
1 AAA
table2:
id dt
=====
1 12
select table1.id as id, table1.surname as surname, table2.dt as dt from table1, table2 where table1.id = table2.id;
--
SC-Networks www: www.SC-Networks.de
Web Design, Netzwerke,
3D Animation und Multimedia
Heiko Irrgang Tel.: 08856/9392-00
Im Thal 2 Fax: 08856/9392-01
82377 Penzberg Mail: Irrgang@SC-Networks.de
