Saturday, April 27, 2013

comma separate mysql join query between two table

SELECT a.*,b.album_name FROM #__simplephotogallery_images a inner join #__simplephotogallery_album b on b.id = a.album_id WHERE FIND_IN_SET('11', `a.album_id`) order by title asc LIMIT 0,20

No comments:

Post a Comment