Professional Web Applications Themes

Join Tables Real Quick - I cant get the syntax rigth. - Microsoft SQL / MS SQL Server

FROM Armast JOIN Aritem ON (UPPER(Armast.fcinvoice) = UPPER(Aritem.fcinvoice)), Aritem JOIN Inmast ON (Aritem.fpartno=Inmast.fpartno AND Aritem.frev=Inmast.frev), Inmast JOIN Inprod ON (Inmast.fprodcl=Inprod.fpc_number) Please help. AA...

  1. #1

    Default Join Tables Real Quick - I cant get the syntax rigth.

    FROM Armast JOIN Aritem ON (UPPER(Armast.fcinvoice) =
    UPPER(Aritem.fcinvoice)),
    Aritem JOIN Inmast ON (Aritem.fpartno=Inmast.fpartno AND
    Aritem.frev=Inmast.frev),
    Inmast JOIN Inprod ON (Inmast.fprodcl=Inprod.fpc_number)

    Please help. AA
    A Guest

  2. #2

    Default Re: Join Tables Real Quick - I cant get the syntax rigth.

    FROM Armast JOIN Aritem ON (UPPER(Armast.fcinvoice) =
    UPPER(Aritem.fcinvoice))
    JOIN Inmast ON (Aritem.fpartno=Inmast.fpartno AND
    Aritem.frev=Inmast.frev)
    JOIN Inprod ON (Inmast.fprodcl=Inprod.fpc_number)


    "A Apodaca" <com> wrote in message
    news:041101c3638f$8f4c47c0$gbl... 


    Rich Guest

  3. #3

    Default Re: Join Tables Real Quick - I cant get the syntax rigth.

    And the UPPER( ) s will probably kill performance on
    the JOIN. Is it really necessary? Are you configured for
    case sensitive?


    "Rich Dillon" <com> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Jason Guest

  4. #4

    Default Re: Join Tables Real Quick - I cant get the syntax rigth.

    Thanks for helping me with that. I just couldn't get the
    syntax right and kept getting errors. Now I see that I
    was messing up the second and third JOIN and also I guess
    I don't need any commas. Thanks again. Alex.
    A Guest

Similar Threads

  1. Inner join query syntax
    By TheScarecrow in forum Coldfusion Database Access
    Replies: 2
    Last Post: January 11th, 04:11 PM
  2. Inner Join syntax
    By lilbuckeye in forum Coldfusion Database Access
    Replies: 15
    Last Post: January 26th, 04:57 PM
  3. FULL JOIN syntax vs (+)
    By Domenic in forum Oracle Server
    Replies: 6
    Last Post: November 13th, 05:06 PM
  4. SQL outer join syntax error
    By Phil Powell in forum PHP Development
    Replies: 3
    Last Post: September 15th, 03:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139