Post reply

need help with ms-access joins

  • October 17, 2004 at 4:48 am

    #60462

    can any 1 tell show me some some samples with ms-access joins

    inner

    left

    right

    any webpage links

    thanks

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • October 17, 2004 at 9:28 am

    #526990

    hey Sukhoi

    since ms access is that of Microsoft..i think\syntax would b similar to that of sqlserver!

    this is jus my interpretation.not sure!!

    if u want some sqlserver joins:

    select * from table1 join table2 on <conditions..>

    select * from table1 left outer join table2 on<conditions>

    select * from table1 right outer join table2 on <conditions..>

  • October 17, 2004 at 9:34 am

    #526991

    Try bulding tehj queries graphically with MS Query Builder and then click the 'SQL' button to see how it is done.

    Query Builder installs with Excel amongst other things. Run the executable MSQRY32.EXE

  • October 18, 2004 at 10:55 pm

    #527112

    well i mean such a simple query i wrote and it doesn't work on ms-access.

    see

    select a.col1,b.col1,a.col2,b.col2 from table1 a join table2 b on

    a.col1=b.col1

    what about left joins, and right joins, i just wanted a syntax summary, with some examples to get ideas

    i searched in ms-access help couldn't find it, searched net, couldn't find it.

    becoz iam extremly used to sql-server, ms-access is just taking time for simple queries.

     

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply