this code

Select filmtype , zhmara FROM query2,query3;

Result

why repeat data

i cant Join, Left Outer Join, Right Outer Join because

my query dont have id or id_fkey

just have...

no different question

thanks GilaMonster, its correct

select COUNT(*) as [type], [group]

from tblname

where group in ('a','b')

Group by [group]

but haw use

where group in ('%a%','%b%')

i can use it