Menu
Community /Pin to ProfileBookmark
@NogDogSep 30.2021 — #Nothing obviously jumps out at me other than...are you positive that
Assuming that's not the issue, I'm curious if there's something different in the way MySQL handles the implicit joins in the
I guess in other words: nope, I don't know. 😉@NogDogSep 30.2021 — #Okay, just spit-balling things here, but wondering if that max date could just be put into the select itself?
Join problem
Here is a query that is giving me an error
[code]
SELECT a.wine_num, a.activity, date_format(a.date_posted,’%m-%d-%y’) as date_mdy, d.activity_desc, a.bottle_cnt, a.my_comments, w.label, w.vintage, CONCAT(s.sort_date, s.wine_num) as sort_col
FROM mywines_activity a, mywines_activity_codes d, mywines w
LEFT OUTER JOIN (select wine_num, max(date_posted) as sort_date
from mywines_activity
group by wine_num) s
on a.wine_num = s.wine_num
WHERE $sel_wine
a.activity = d.activity_code and
a.wine_num = w.wine_num
ORDER BY sort_date Desc, a.wine_num
The message is that ‘a.wine_num’ in the ON clause of my join does not exist. The query works fine without the join, so I can’t figure this out.
Here’s the actual message:
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘a.wine_num’ in ‘on clause’ in /home/albany/public_html/homejg/wine_activity_review.php:103 Stack trace: #0 /home/albany/public_html/homejg/wine_activity_review.php(103): PDO->prepare(‘SELECT a.wine_n…’) #1 {main} thrown in /home/albany/public_html/homejg/wine_activity_review.php on line 103
Any ideas?
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogSep 30.2021 — #Nothing obviously jumps out at me other than...are you positive that mywines_activity.wine_numonAssuming that's not the issue, I'm curious if there's something different in the way MySQL handles the implicit joins in the
FROMFROMINNER JOINI guess in other words: nope, I don't know. 😉
0
@NogDogSep 30.2021 — #Okay, just spit-balling things here, but wondering if that max date could just be put into the select itself?[code=sql]
SELECT
a.wine_num,
a.activity,
date_format(a.date_posted,'%m-%d-%y') as date_mdy,
d.activity_desc,
a.bottle_cnt,
a.my_comments,
w.label,
w.vintage,
CONCAT(
(
select max(date_posted)
from mywines_activity
where wine_num = a.wine_num
)
) as sort_col
FROM mywines_activity a
INNER JOIN mywines_activity_codes d on a.activity = d.activity_code
INNER JOIN mywines w on a.wine_num = w.wine_num
WHERE $sel_wine
ORDER BY sort_date Desc, a.wine_num
[/code]