there is no problem with the query . You might need to change the join condition . Kindly post both of your tables structure for more details.
debasisdas 580 Posting Genius Featured Poster
debasisdas 580 Posting Genius Featured Poster