Re: [SQLObject] select from multiple tables

[Oleg B. <ph...@ma...>]

On Fri, Sep 08, 2006 at 03:58:42PM +0200, Ivan Horvath wrote:
> SELECT history.username, objects.type, objects.obj_file, history.datetime, history.comment FROM objects, history WHERE (((history.username) = ('Ivan')) AND ((objects.id) = (history.objects_id))) ORDER BY (history.datetime, objects.type)
> 
> OperationalError: (1241, 'Operand should contain 1 column(s)') error

   Try to run the query directly on the server, from the command line. Try
to simplify the query - remove ORDER BY, do ORDER BY one parameter or the
other...

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.