Hi There,
If I interpreted what you are trying to do is to return all the rows from
Challenge and reference Patrocinio excluding those rows in Patrocinio where
PTRN_ID is 1?
Not sure if the below is possible in MySQL but I've used this in other places
when doing a left join and needing to
G'day all,
Is it possible to use a query as a source for another query? For
example...
Query 1:
SELECT COUNT(*) AS TotalSurveys, SurveyDate FROM Surveys GROUP BY
SurveyDate;
Query 2:
SELECT MIN(TotalSurveys) AS MinSurveys, MAX(TotalSurveys) AS MaxSurveys
FROM Query 1;
I am using 3.23.53 on a