[Resolved] Please help with joined query

[ppowell]

SELECT DISTINCT x.id, x.partner_name, y.interns_id FROM partners x LEFT JOIN intern_partner_allowed_assoc y ON y.partners_id = x.id AND y.interns_id = '734'

This query in MySQL 4.0.17 produces a fatal error:

Fatal error: Unknown column 'y.interns_id' in 'field list' using query: SELECT DISTINCT x.id, x.partner_name, y.interns_id FROM partners x LEFT JOIN intern_partner_allowed_assoc y ON y.partners_id = x.id AND y.interns_id = '734'

This is telling me y.interns_id can't be called, but that is a problem because I MUST have that value returned for the logical construct of a display that is wholly determined on whether or not "y.interns_id" is NULL or has a value.

What do I do?

Thanx
Phil

[devinemke]

mySQL is telling you that interns_id does not exits in the y table.

[ppowell]

I discovered this one moments after posting. This was truly a dumb topic of me to bring up.

Phil