sql - Wildcard for BigI -

i using orcale database create filtering system in java , want display customer id, type big integer in program. using sth

select distinct project.name  project inner join cust on project.cust_id = cust.cust_id  project.name  '%'  ,  cust.cust_id '%' ; 

however getting, column ambiguously defined

that because cust biginteger , not work here. basically, want have in part and cust structure, because of filtering. however, want display biginteger ids. use can values cust?

i appreciate answer!

i don't think column ambiguously defined types; it's column names. typically happens when include column in select clause appears on more 1 of tables joined in query. try giving tables aliases:

select distinct p.name  project p  inner join cust c on (c.cust_id = p.cust_id) p.name '%'  ,  c.cust_id '%';