sql problem

[dethfire]

sqlAccounts = "SELECT *.sub, schoolname.schls FROM submissions AS sub LEFT OUTER JOIN schools AS schls ON schoolid.sub = schoolid.schls WHERE schoolid=" + id;

error:
Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression '*.sub'.

[redemption]

What did you mean by *.sub?

Did you want to get all fields in the sub table? Then it should be sub.*

EDIT:
I noticed your join condition has a "schoolid.sub". Did you mean "sub.schoolid" instead? Remember that the syntax is table_name.field_name.

[dethfire]

ah yes, my alias were messed up, thanks