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?

php mysql

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Country State City Dropdown list in PHP MySQL PHP

Country state city dropdown using ajax in php. You'll learn how to populate country city state dropdown based on previous selection in php using ajax

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Compare ScaleGrid MySQL vs. DigitalOcean Managed Databases - See which offers the best MySQL throughput, latency, and pricing on DigitalOcean across workloads.

Ajax Live Data Search using jQuery PHP MySQL

ajax php live search with mysql database example. Here you will learn how to implement ajax live data search using php mysql database with example

Category Subcategory Dropdown in PHP MySQL Ajax

PHP mysql dynamic dropdown list onchange. Here, we'll show how to populate category and subcategory in dropdown list using ajax in PHP mysql

PHP Code for Update Data in MySQL Database - Tuts Make

PHP code for updating data in mysql database. Here we'll show you how to fetch and update form data into mysql database using PHP code. &demo