View previous topic :: View next topic
|
Author |
Message |
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
Hi ALL,
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..? |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
SELECT *
FROM "SYSIBM".SYSCOLUMNS --
WHERE NAME IN ('KNID','BRID')
ORDER BY TBNAME,TBCREATOR
This is the best query i can write ......... |
|
Back to top |
|
|
Alan Voss
New User
Joined: 29 Nov 2006 Posts: 32 Location: Jacksonville, FL
|
|
|
|
Try this:
Code: |
select tbcreator,tbname,
count(*) as trows
from sysibm.syscolumns
where name in ('KNID','BRID')
group by TBCREATOR,TBNAME
having count(*) = 2;
|
|
|
Back to top |
|
|
|