Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more
COURSE of the MONTH
12 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL Query stopped returning Data
Posted on 2013-01-03
Say,
Data stored in MySql 5 running on Win7
Since moving it from linux MySql DB the join query below doesn't return data: If I remove the join - tTop10NosByCallType returns data.
Can you explain it and how to solve please?
SELECT
*,
tDirectory.`CallerID` AS tDirectory_CallerID,
tDirectory.`Category` AS tDirectory_Category,
tDirectory.`Access` AS tDirectory_Access,
tDirectory.`Status` AS tDirectory_Status
FROM
`tDirectory` tDirectory LEFT OUTER JOIN `tTop10NosByCallType` tTop10NosByCallType ON tDirectory.`TelNo` = tTop10NosByCallType.`No`
WHERE
tTop10NosByCallType.Client
and `Invoice number` = $P{InvNo}
ORDER BY
CallType DESC,
CountByCallType DESC,
DurationHHMM DESC
Data stored in MySql 5 running on Win7
Since moving it from linux MySql DB the join query below doesn't return data: If I remove the join - tTop10NosByCallType returns data.
Can you explain it and how to solve please?
SELECT
*,
tDirectory.`CallerID` AS tDirectory_CallerID,
tDirectory.`Category` AS tDirectory_Category,
tDirectory.`Access` AS tDirectory_Access,
tDirectory.`Status` AS tDirectory_Status
FROM
`tDirectory` tDirectory LEFT OUTER JOIN `tTop10NosByCallType` tTop10NosByCallType ON tDirectory.`TelNo` = tTop10NosByCallType.`No`
WHERE
tTop10NosByCallType.Client
and `Invoice number` = $P{InvNo}
ORDER BY
CallType DESC,
CountByCallType DESC,
DurationHHMM DESC
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
- +1
6 Comments
Move below where condition to join .... I mean with on
tTop10NosByCallType.Client
tTop10NosByCallType.Client
SELECT
*,
tDirectory.`CallerID` AS tDirectory_CallerID,
tDirectory.`Category` AS tDirectory_Category,
tDirectory.`Access` AS tDirectory_Access,
tDirectory.`Status` AS tDirectory_Status
FROM
`tDirectory` tDirectory LEFT OUTER JOIN `tTop10NosByCallType` tTop10NosByCallType ON tDirectory.`TelNo` = tTop10NosByCallType.`No` and
tTop10NosByCallType.Client = $P{Client}
WHERE
`Invoice number` = $P{InvNo}
ORDER BY
CallType DESC,
CountByCallType DESC,
DurationHHMM DESC
Active today
Just a thought ... the above T-SQL uses * to return all columns, but you have two queries in your table. So is the intent here to return all columns from both tables, or one, or the other?
tDirectory.*
tTop10NosByCallType.*
* -- this is the same as saying both of the above
tDirectory.*
tTop10NosByCallType.*
* -- this is the same as saying both of the above
Active today
Tx.
1. I replaced pasted your code above, but same issue - no data. Wasn't sure what you meant by the comment though.
2. The same issue with just a *
I need fields from both tables
1. I replaced pasted your code above, but same issue - no data. Wasn't sure what you meant by the comment though.
2. The same issue with just a *
I need fields from both tables
Active 2 days ago
Try with literal values for $P{InvNo} and $P{Client}. I think the issue may be that Windows does not like those for variable names.
Featured Post
Learn why container technology is so powerful and how it can provide your team with productivity gains and other benefits.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this article, we’ll look at how to deploy ProxySQL.
- Databases
- Network Analysis
- Network Operations
- Network Security
- MySQL Server
- Network Architecture, Percona, *proxy servers, *Data Migration
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
- Server Hardware
- IT Administration
- Disaster Recovery
- Storage Software
- Databases
- Storage Hardware, MySQL Server, Hardware, Percona, *Backups
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month12 days, 11 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.