Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dannymm

  1. dannymm

    Multiple Column Outer Join

    Thanks a lot dave. The query works fine now. Danny !
  2. dannymm

    Multiple Column Outer Join

    Hi Mufasa, I have encountered one more problem here. There are some rows in child which do not have any relation with parent i,e id1,id2 and id3 are blank. How can i modify the above query so that it will fetch all those child rows which do not have any relation with parent. Regards, Danny !
  3. dannymm

    Multiple Column Outer Join

    Thanks SantaMufasa, the union works fine for me. This was just a dummy table structure (since i can't post the actual table strucure here), anyways thanks for highlighting :) Regards, Danny !
  4. dannymm

    Multiple Column Outer Join

    Hi, I have a problem with multiple column outer join. Here is my schema Table: parent module : Integer name : varchar id : Integer desc : Text Table: child module : Integer id1 : Integer id2 : Integer id3 : Integer status : Char(1)...
  5. dannymm

    Mysql+PHP to PostGres+PHP ?

    Hi Guys, I have some issues with postgres. We are planning to port a Billing Application from MySQL+PHP to PostGres 7.1+PHP. The issues are maily with capitalized column names. My Table Name: NetworkName Column Name1 : NetCode Column Name2 : NetworkName All over the application we have used...

Part and Inventory Search

Back
Top