[blackwidow18]

Trying to run a query like this:

Код:

SELECT blah.id, blah.name, blahblah.number, hey.message FROM blah
LEFT JOIN blahblah ON blah.id = blahblah.id
LEFT JOIN hey ON blah.name = hey.id
WHERE blah.age = 2

(same concept as the actual query I'm running)

The result is:

Quote:

Error: Unknown table 'blah' in field list

The main "from" table is apparently AWOL.

While running the same query in PHPMyadmin it runs fine and fetchs all 8 values correctly. I am using R7. Considering the query works fine otherwise, I don't see what the problem is unless its in the plugin. The connection is active and yes it is to the right database. It can also see/access the table in a simpler query.