-
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.
-
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
-
Forum Rules
|
|