Results 1 to 3 of 3
Thread: sql problem
May 1, 2003, 22:59 #1
sqlAccounts = "SELECT *.sub, schoolname.schls FROM submissions AS sub LEFT OUTER JOIN schools AS schls ON schoolid.sub = schoolid.schls WHERE schoolid=" + id;
Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression '*.sub'.
May 1, 2003, 23:58 #2
- Join Date
- Sep 2001
- 0 Post(s)
- 0 Thread(s)
What did you mean by *.sub?
Did you want to get all fields in the sub table? Then it should be sub.*
I noticed your join condition has a "schoolid.sub". Did you mean "sub.schoolid" instead? Remember that the syntax is table_name.field_name.
May 2, 2003, 00:12 #3
ah yes, my alias were messed up, thanks