Error Code: 1054. Unknown column Help!

Question

Hey, I'm having issues with my inner join. I cant work out the issue. Here is the error code -

 

1000 Error Code: 1054. Unknown column 'bands.band_id' in 'on clause' 0.000 sec

 

here is the sql - 

 

SELECT bands.band_id, cds.position
FROM bands, cds
INNER JOIN releases
ON bands.band_id=releases.band_id AND bands.band_name='Kylie Minogue' AND cds.position='1'; 

 

Any help out there? Thank you.