Menu
Community /Pin to ProfileBookmark
@NogDogFeb 13.2019 — #I don't know why they would have different results unless the actual data is different, but this looks a bit iffy:
Do you get anything better if you consolidate that to a single join?
MySWL Table join inconsistencies
I have an SQL statement which Joins 3 tables and then produces some results.
PROBLEM: DB Fiddle actually gives me the correct results BUT My Database: Version: 10.0.38-MariaDB – Gives different results.
Both DBs show all 48 rows when the `sale_category=’Non-Productive’
BUT – Only DB Fiddle filters correctly to 15 rows of data when the `sale_category=’Non-Productive’
My MariaDB filters incorrectly resulting in 32 rows of data. (see attached)
My database is displaying results which should be filtered (e.g. any row with sale_type=CUSTOMER) BUT is showing them as ‘Non-Productive’ and I have no idea why (especially after testing in DB Fiddle and seeing desired results)
1. Why is it so?2. Is there a more efficient SQL query?
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogFeb 13.2019 — #I don't know why they would have different results unless the actual data is different, but this looks a bit iffy:<i>
</i>INNER JOIN ReportHeader rh1 ON rd.report_id=rh1.id
INNER JOIN ReportHeader rh2 ON st.customer_id=rh2.customer_id
Do you get anything better if you consolidate that to a single join?
<i>
</i>INNER JOIN ReportHeader rh1 ON rd.report_id=rh1.id AND st.customer_id=rh1.customer_id