On Fri, 29 Jun 2001, Krzysztof Kowalski wrote:
> Hi, I'm a new user, and I have question: I have 2 tables
> info (table1)
> -----------------
> id | data | naglowek | kto | link
>
> news (table2)
> -----------------
> id | data | naglowek | kto | link | email | tresc | inne
>
> and I want to generate one big tabele contains those 2 (table1 and
> table2). It's something like this: "SELECT * FROM table1,table2" but
> this wan't work. Thanks for help.
> Krzysiek
select i.*,n.* from info i, news n where i.id=n.id;
a.
>
> -----------------------------------------------------------------------
> Jagged Alliance 2,5 Unfinished Business PL już w sprzedaży!
> Kliknij < http://gry.wp.pl/opisy/jagged_alliance_2.html >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
-------------------------------------------------------------------------------
Dr Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
-------------------------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php