Results 1 to 2 of 2

Thread: Make one table from two tables?!?!?

  1. #1
    Join Date
    Apr 2003
    Location
    Yu/Europe
    Posts
    1

    Question Make one table from two tables?!?!?

    Need help.

    I have two tables and want to see it as one.
    <<t1 >> ID smallint, NAME varchar(50).
    <<t2>> ID smallint,ADDRESS varchar(50). (ID is the same like in first table. ID is not autoincrement but defined by user- that is me ! ). Here I have numbers like, 1,2,5,13,14,15,16,... not successive )

    I want to make one new table that have:
    <<t3>> ID smallint,NAME varchar(50),ADDRESS varchar(50).

    I am using MySQL Server 4.0.12 for Windows.

    Thank you.
    Aleksandar Smolovic
    Last edited by Aco; 04-14-2003 at 07:22 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    select a.id, a.name, b.address from t1 a, t2 b where a.id=b.id

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •