Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
I need to find the tables which contain the columns KNID & BRID on the same table. I queried the catalog table SYSIBM.SYSCOLUMNS and because of my poor knowledge in SQL i couldnt find the table containing both the columns on the same table. I mean i couldnt write the sql query for that :)
I know we can find the tables containing on of theses columns. Do anyone have idea about this..?