By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,719 Members | 1,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,719 IT Pros & Developers. It's quick & easy.

correct my error in query

P: 15
iam getting the error as follows
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in FROM clause

following is the showing error

my_sql="SELECT company_name,[tran_date] FROM data as T"&"WHERE [tran_date]=(select max[tran_date] from data & where company_name=T.company_name)"
Jan 25 '07 #1
Share this Question
Share on Google+
2 Replies


shweta123
Expert 100+
P: 692
Hi,

Hope you still need this,

try writing the query this way

my_sql="SELECT company_name,[tran_date] FROM data as T"&" WHERE [tran_date]=(select max[tran_date] from data & where company_name=T.company_name)"

Give spaces before Where clause.

Shweta
Feb 13 '07 #2

iam_clint
Expert 100+
P: 1,208
my_sql="SELECT company_name,[tran_date] FROM data T WHERE [tran_date]=(select max[tran_date] from data & where company_name=T.company_name)"
Feb 13 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.