Dear sqlobject,
 
i would like to select fields from more tables
 
here is the code, what i have:
        fields = [VssHistory.q.username, VssObjects.q.type, VssObjects.q.objFile, VssHistory.q.datetime, VssHistory.q.comment]
        where = sqlbuilder.AND(VssHistory.q.username == self.cUserName, VssObjects.q.id == VssHistory.q.objectsID)
        orderby = [VssHistory.q.datetime, VssObjects.q.type]
        sql = conn.sqlrepr(sqlbuilder.Select(fields, where, orderBy=orderby))
it creates this sql command:
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)
when i execute with
        res = conn.queryAll(sql)
i receive
OperationalError: (1241, 'Operand should contain 1 column(s)') error
please help me what is wrong?

Best regards, 
    Ivan Horvath
 
    Chief Programmer
 
 
 Alcatel ISD
 
 PMS 2000 Product Team
 
 
 H-1116, Budapest
 
 Kondorfa u. 10.
 
 Tel.: +36 1 209 9546
 
 Fax.: +36 1 209 9599
 
 Mobil: +36 30 257 0235
 
 VOIP: +49 511 676 478010
 
 
i.horvath@alco.co.hu
 

Anyone who has never made a mistake has never tried anything new.
 

/Albert Einstein/