I need some help on a query...I have 2 LEFT JOINS and I would like to only JOIN selective fields from each of the LEFT JOIN tables....here is my query below:
SELECT * FROM assign_images
LEFT JOIN users on assign_images.userID=users.userID
LEFT JOIN assignment on assign_images.assign_id=assignment.id
WHERE assign_images.image_id='123456'
So I would only like select fields from users and from assignment....is this possible? If not then what would be the best wat I could acheive this?.....
SELECT * FROM assign_images
LEFT JOIN users on assign_images.userID=users.userID
LEFT JOIN assignment on assign_images.assign_id=assignment.id
WHERE assign_images.image_id='123456'
So I would only like select fields from users and from assignment....is this possible? If not then what would be the best wat I could acheive this?.....