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 !
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 !
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)...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.