in

Share your IT thoughts...

I N F O R M A T I O N   T E C H N O L O G Y   P O R T A L   O F   E X P E R T S
Forums » Technology Discussions » Database » How to add same fields to two tables with single query?
Latest post Tue, Aug 12 2008 3:38 AM by NinethSense. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next

  • Wed, Aug 6 2008 5:10 AM

    • asha_k
    • Top 25 Contributor
    • Joined on Wed, Aug 6 2008
    • Beginner
    • Points 40

    How to add same fields to two tables with single query?

    Reply Contact

    Is it possible to add two fields with same name and same properties to two different tables in the same database?
    • Post Points: 20

  • Wed, Aug 6 2008 5:11 AM In reply to

    • NinethSense
    • Top 10 Contributor
    • Joined on Mon, Jun 30 2008
    • India
    • Sr. Developer
    • Points 1,825

    Re: How to add same fields to two tables with single query?

    Reply Contact

    Which database? MSSQL?

    PraVeeN
    blog.ninethsense.com/ | kidoos.net
    • Post Points: 20

  • Wed, Aug 6 2008 5:12 AM In reply to

    • asha_k
    • Top 25 Contributor
    • Joined on Wed, Aug 6 2008
    • Beginner
    • Points 40

    Re: How to add same fields to two tables with single query?

    Reply Contact

    I use SQL Server 2005. If it is not pobbile with SQL Server 2005, any other database allow this?
    • Post Points: 20

  • Mon, Aug 11 2008 2:04 PM In reply to

    • Shoban
    • Top 10 Contributor
    • Joined on Fri, Jul 25 2008
    • Trivandrum
    • Developer
    • Points 565

    Re: How to add same fields to two tables with single query?

    Reply Contact

    You should be able to do it without any issues.. It works in MySql ... This question was a simple one Smile.. Did I miss anything??

    Crankup
    Shoban Kumar
    My tech blog
    • Post Points: 20

  • Tue, Aug 12 2008 12:07 AM In reply to

    • NinethSense
    • Top 10 Contributor
    • Joined on Mon, Jun 30 2008
    • India
    • Sr. Developer
    • Points 1,825

    Re: How to add same fields to two tables with single query?

    Reply Contact

    Shob... what is the MySQL query for that?

    PraVeeN
    blog.ninethsense.com/ | kidoos.net
    • Post Points: 20

  • Tue, Aug 12 2008 2:34 AM In reply to

    • Shoban
    • Top 10 Contributor
    • Joined on Fri, Jul 25 2008
    • Trivandrum
    • Developer
    • Points 565

    Re: How to add same fields to two tables with single query?

    Reply Contact

    Again, did I mis something.. I just used the front end to create 2 tables.. with the same field name? Angry

    Crankup
    Shoban Kumar
    My tech blog
    • Post Points: 20

  • Tue, Aug 12 2008 3:38 AM In reply to

    • NinethSense
    • Top 10 Contributor
    • Joined on Mon, Jun 30 2008
    • India
    • Sr. Developer
    • Points 1,825

    Re: How to add same fields to two tables with single query?

    Reply Contact

    Shob,

    Her question is how to add a field to TWO tables with SINGLE query.

    PraVeeN
    blog.ninethsense.com/ | kidoos.net
    • Post Points: 5
Page 1 of 1 (7 items)
© Kidoos 2008 - Dedicated Technology Portal of Kidoos
kidoos.net | Contact | About