Hi I'm currently trying to write a semi complex insert statement.

I have been able to use insert and select together, however am having
to luck in adding addition fields to the update.

This works OK

INSERT INTO picture (`GalleryID`, `Team` )
SELECT galleries.GalleryID, categories.Team
FROM galleries
CROSS JOIN categories
WHERE galleries.GalleryName = 'Holiday Pictures' AND categories.Team =
'2'

However want to update more rows with data

Need to insert values to fields like FileName, Date, Caption etc....
This information is coming directly from the page, generated from iptc
information etc. How do I go about this... Its not the standard INSERT
INTO () VALUE () statement

I'm using mySQL..

Any ideas.

Thank you