Post reply

Can I use the same alias for different tables within one store procedure?

  • December 7, 2010 at 7:55 am

    #388382

    Can I use the same alias for different tables within one store procedure? For example, does code below create an error?

    select * from Order o inner join Customer c on c.orderid = o.orderid

    select * from OrderHistory o inner join Customer c on c.orderid = o.orderid

    Both tables, Order and OrderHistory are using the same alias o, is it ok?

  • December 7, 2010 at 7:59 am

    #1259540

    that's fine

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • December 7, 2010 at 8:23 am

    #1259566

    the rule of thumb is each object in a statement must be uniquely identifyable, whether by object name or by alias;

    in your example, each sql is standalone and following the rules just fine.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 7, 2010 at 11:48 am

    #1259723

    Hi

    There will not be problem in your query defiantly it will work, Better keep alias separately so that your code may look gud

    Note: You can also have or use same alias name

    Thanks

    Parthi

    Thanks
    Parthi

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

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