Damanindahaus
New Member
hello colleagues,
maybe i am bit "blem blem" now after coding over hours. but how can i solve this problem?
i have a select that returns 100k entries and i wanna select another column from another table, too. but the resultset must not reduce. e.g.:
--returns 100k entries
select ca from table1
--just returns 24k entries
select a.ca, b.cb from table1 a, table2 b
where a.id = b.id
and b.anothercolumn like '%hey%'
is there another way to select b.anothercolumn without cutting the other entries? i m a bit confused right now?
regards
Daman
maybe i am bit "blem blem" now after coding over hours. but how can i solve this problem?
i have a select that returns 100k entries and i wanna select another column from another table, too. but the resultset must not reduce. e.g.:
--returns 100k entries
select ca from table1
--just returns 24k entries
select a.ca, b.cb from table1 a, table2 b
where a.id = b.id
and b.anothercolumn like '%hey%'
is there another way to select b.anothercolumn without cutting the other entries? i m a bit confused right now?
regards
Daman