hello, what i am trying but failing at is this. i am trying to create a mysql statment that will insert in to the table event and do four look up for ids form four differen't tables. below is the statment that i have but i can't find were i messing up on the syntax to get this done.
INSERT INTO `event` ( `event_id` , `event_name` , `event_days` , `attendees_id` , `food_id` , `setting_id` , `sca_group_id` )
values (
NULL,'College of Brymstonne',1,
SELECT `attendees_id` FROM `attendees` WHERE `attendees_name` LIKE '200-300',
SELECT `food_id` FROM `food` WHERE `food_name` LIKE 'Buffet Feast',
SELECT `setting_id` FROM `setting` WHERE `setting_name` LIKE 'indoor',
SELECT `sca_group_id` FROM `sca_groups` WHERE `sca_group_name` LIKE 'College of Brymstonne')
any help or were to look would be more then welcome!
