How to i use join?

Question

I get a "syntax error in from clause" exception error. I write OleDB. What is the reason?

string selectCommand = @"SELECT * FROM A JOIN B ON A.ID=B.ID";

Please help, Thanks.

Answer 1

Use any of the inner, outer. left, right, etc join

string selectCommand = @"SELECT * FROM A INNER JOIN B ON A.ID=B.ID";