Can we use join keyword without using INNER keyword explicitly in.

[S.SRIKANTH,GUDIWADA,AP,INDIA]

hi,

i have a query as follows, which is working fine in sqlserver.
select a.lookup_group_id from lookup a join lookup_group b on
a.lookup_group_id = b.lookup_group_id

if it is working with msaccess also, then i need not modify the query, in my
code now.
can i continue with above query? or i should modify it?

If all your suggestions to modify. i will continue my work with following
query...
what i know is, the following is working fine in both databases :
INNER JOIN KEYWORD MUST BE USED
select a.lookup_group_id from lookup a INNER join lookup_group b on
a.lookup_group_id = b.lookup_group_id
thanQ

[JohnFol]

The quick way to find out is to cut and paste the SQL as above into a new
query in SQL view. Chances are it will be ok.

If the tables exist on SQL, the query needs to be a passthrough.

"S.SRIKANTH,GUDIWADA,AP,INDIA"
<SSRIKANTHGUD...@discussions.microsoft.com> wrote in message
news:0FDE893D-5B62-4DFA...@microsoft.com...