Copy Records from two tables to new Table

[ak1dnar]

I have two table in my end.
Clinics
Hospitals

Now I need to get some records from this Query and Insert them to a new table

[CODE=sql]SELECT
Clinics.clinic_ no,
Clinics.Hosptl_ no,
Hospitals.Hospt l_no,
Hospitals.hospt l_name
FROM Clinics
INNER JOIN Hospitals ON Clinics.Hosptl_ no = Hospitals.Hospt l_no
[/CODE]

[hariharanmca]

I have two table in my end.
Clinics
Hospitals

Now I need to get some records from this Query and Insert them to a new table

[CODE=sql]SELECT
Clinics.clinic_ no,
Clinics.Hosptl_ no,
Hospitals.Hospt l_no,
Hospitals.hospt l_name
FROM Clinics
INNER JOIN Hospitals ON Clinics.Hosptl_ no = Hospitals.Hospt l_no
[/CODE]

you can try this

insert into NewTableName (Field1, Field2, Field3, Field4) SELECT 
Clinics.clinic_no,
Clinics.Hosptl_no,
Hospitals.Hosptl_no,
Hospitals.hosptl_name
FROM Clinics
INNER JOIN Hospitals ON Clinics.Hosptl_no = Hospitals.Hosptl_no

[ak1dnar]

Thanks a bunch hariharanmca.

[hariharanmca]

Thanks a bunch hariharanmca.

You are most welcome moderator

[ak1dnar]

You are most welcome moderator

Mod for PHP-Forum not to here :)

[hariharanmca]

Mod for PHP-Forum not to here :)

okay, No problem...cool