Posted by Mintyman on 09/20/05 15:23

Hi,

I have a SQL query:

select products.name, products.notes, products.purchase_date,
products.serial_no, products.total_value, products.product_code,
products.quantity, products.product_group, products.lhs1_name,
lhs1.department, lhs1.address1, lhs1.city, lhs1.country
from products, lhs1
where products.lhs1_id = lhs1.id

I want to insert the results of this query into a table called 'temp' in the
database. I used to copy and paste this into excel then import it but it
doesn't always work.

Is there a way to do it all in a SQL script. Please be aware that my
knowledge of SQL is fairly basic so please explain things clearly.

Thanks,

Darren

• Next in forum: Insert based on a select query
• Prev in forum: Insert based on a select query
• Thread view: Insert based on a select query

[Reply to this message]