MySql INNER JOIN IN not getting right result

MySql INNER JOIN IN not getting right result

I have this query in my php and it seems to be fetching the wrong data set from my db.

I have this query in my php and it seems to be fetching the wrong data set from my db.

 $querystring = "SELECT a.*, b.itemColour,b.itemColourName FROM itemorders 
 AS a INNER JOIN CatalogueItemsColour AS b ON a.colourID = b.colourID WHERE 
  a.colourID IN(SELECT colourID FROM itemorders where orderID = 
  61 ) ";

Here is a picture of my results

Can i know why its not selecting the specific orderID of 61?

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

PhP MySQL Projects

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts and trainers.

The Complete PHP MySQL Professional Course with 5 Projects

The Complete PHP MySQL Professional Course with 5 Projects

PHP Interview Questions with Solutions: Prepare for PHP Interview

Prepare for PHP Interviews. Set Variable With php.ini File. Logic & Output Behind PHP Code Segment. Class Concept, Error & Functions in PHP. Start PHP Now!