viktor
|
| Posted: 04/08/2005, 7:22 AM |
|
Is it possible to "compare" data of two grids?
i.e. we have "Grid1" and "Grid2".
Grid 1 shows field1_id - 1,2,3,4,7,8,9
Grid 2 shows field2_id - 1,2,3,4,5,6,7,8,9
How to make Grid 2 not to show what is in Grid 2. That is - 6, 7 only.
These two grids are based on two different tables. But since table 2 for Grid 2 has field2_id as "duplicatable" I can not put them both in a query. I have tried already DISTINCTROW etc in MySQL - no luck
Maybe there is a simple way of doing it in CCS in the very Grid?
Thanks for assistance!
Viktor
|
|
|
 |
mrachow
Posts: 509
|
| Posted: 04/10/2005, 3:32 AM |
|
Hi victor,
I would suggest to filter by SQL.
Quote :But since table 2 for Grid 2 has field2_id as "duplicatable" I can not put them both in a query .
You should always be able to precede ec´very column by table name.
If you use Studios Data Source dialog it will be done automatically for columns occuring in more than one table.
A potential problem I see is that only the newest versions of MySQL are supporting subqueries and I think they are needed here.
_________________
Best regards,
Michael |
 |
|
viktor
|
| Posted: 04/19/2005, 4:34 AM |
|
Here is a good source for rewriting subqueries for earlier versions of mysql
|
|
|
|
viktor
|
| Posted: 04/19/2005, 5:04 AM |
|
Here is a good source for rewriting subqueries for earlier versions of mysql
http://dev.mysql.com/doc/mysql/en/rewriting-subqueries.html
|
|
|
|
|
