asked on SQL Query stopped returning Data
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
MySQL ServerSQL
Last Comment
Shaun Wingrin
ASKER
Do you need to see the tables?
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
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
ASKER
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
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Moved back to Linux...