I have the following database structure:
TABLE 'images' (id,name,format) TABLE 'objects'(id,title) TABLE 'images_objects'(id,image_id,object_id)
object_id are the foreign keys to
images_objects table respectively. So I filled the first two tables, now I want to populate the third table with id pairs. Which SQL QUERY should I construct?