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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
Back
Top