www.webdeveloper.com
Results 1 to 2 of 2

Thread: Firebird, rows as columns?

  1. #1
    Join Date
    Sep 2007
    Posts
    18

    Question Firebird, rows as columns?

    I use firebird 2.0

    I have two tables:

    1- Product
    with some columns :
    ProductID, ProductCode...

    2- PriceList
    with some columns :
    ProductID, Price...

    * A Product may have many prices

    The user wants to see the Product list with corresponding prices on the same row.

    Any idea how to achieve this. Thanks.

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    isn't this just a basic join?

    Code:
    select productid,productcode,price from product p, pricelist pl where p.productid=pl.productid
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles