Problem with Group By

[prometro]

Hi, I did several linked queries and the result is OK. Only problem is that I cannot modify result data from query.

I believe It is basic thing but I cannot find solution ....
Everything is in appendix.

 

[stopher]

Yes, grouping will inevitably mean you can't update the records.

But if I understand correctly, you just want to be able to update t1 but limit the records to those corresponding in t2. Try this:

SELECT idTab1, text1, text2
FROM t1
WHERE idtab1 in (
SELECT DISTINCT idTab1 FROM t2)

Hopefully it's self explanatory. Shout if not.

Chris

 

[prometro]

Ouujeéé! It works and it is easy! Thank you Chris!