Actually i was able to compare two rows in same table after inner joining them from multiple tables
But was only able to compare one field
As you can see in the image
where cur.product_id=100
but i also want to check
cur.product_id=200 ,
but when i include
where cur.product id=100 and cur.product_id=200 ,
it returns empty table , how can i fix it.
The image is attached below
- This topic was modified 4 years, 7 months ago by ranadas.
Attachments:
You must be
logged in to view attached files.