Hi, I have been trying for 4 days but I can't solve this problem and I
don't know why.
It's a bug?
I have a table (children) which has a field called borough; I have to
extract the sum of the children of each borough so I use this simple
query:
select count(*) , borough from children group by bo
Hi.
I have this table (A)
IDJOB ¦ IDKIT
4 ¦ 19
4 ¦ 19
2 ¦ 19
2 ¦ 5
I need to extract IDKIT with IDJOB<>2 if and only if IDKIT <> IDKIT when
IDJOB=2
In this case my query should return null
With a subquery I can do this and it works
SELECT idkit from A where A.i
Hi
I'm trying to extract data from 2 tables (A and B) with a subquery
A has the fields (ID_person, name)
B has the fields (ID_person,ID_country)
This is my query
select *
from A
where A.id_person IN (select B.id from B where B.ID_country =7)
But I receive a message error.
If I try to run each
