# What happen with MySQL 5?

**URL:** <https://forums.percona.com/t/what-happen-with-mysql-5/72>\
**Category:** Other MySQL® Questions\
**Created:** [August 25, 2006, 5:17am UTC](https://forums.percona.com/t/what-happen-with-mysql-5/72 "2006-08-25T05:17:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![safari](https://avatars.discourse-cdn.com/v4/letter/s/838e76/32.png) [@safari](https://forums.percona.com/u/safari)\
**Post date:** [August 25, 2006, 5:17am UTC](https://forums.percona.com/t/what-happen-with-mysql-5/72/1 "2006-08-25T05:17:18Z")

</div>

The following query can run on MySQL 4.1 but can not on MySQL 5.0.x:

SELECT c.\*, rst.starttimenameFROM tblcourse c, tblcourse\_category\_extra ceLEFT JOIN tblref\_starttime rst ON rst.starttimeid = c.starttimeidWHERE ce.courseid = c.courseidORDER BY c.approveddate DESC

Anyone can help to explain?

Thanks.

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [August 25, 2006, 5:47am UTC](https://forums.percona.com/t/what-happen-with-mysql-5/72/2 "2006-08-25T05:47:34Z")

</div>

It would be helpful if you explain what do you mean by can’t be run - is it way to slow or what is error message ?

I would guess you’re mentioning

tblcourse table field in the LEFT JOIN clause which is forbidden in MySQL 5.0 - only joined tables can be refered in ON clause.

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [August 26, 2006, 12:47am UTC](https://forums.percona.com/t/what-happen-with-mysql-5/72/3 "2006-08-26T00:47:13Z")

</div>

safari,

try next query

SELECT c.\*, rst.starttimenameFROM (tblcourse c, tblcourse\_category\_extra ce)LEFT JOIN tblref\_starttime rst ON rst.starttimeid = c.starttimeidWHERE ce.courseid = c.courseidORDER BY c.approveddate DESC

Syntax was changed in 5.0.13

---

<div class="post-metadata">

**Author:** ![safari](https://avatars.discourse-cdn.com/v4/letter/s/838e76/32.png) [@safari](https://forums.percona.com/u/safari)\
**Post date:** [August 27, 2006, 8:57pm UTC](https://forums.percona.com/t/what-happen-with-mysql-5/72/4 "2006-08-27T20:57:49Z")

</div>

it works now. thanks vadim.