Hi listers,
Thanks to Robert Crossley, Andrew Williams and Peter Horsboll Moller for
replying to my post.
I was on the right track but to get all combinations of intersecting regions, I
had to use the SQL select instead of update table.
The most correct and useful info and code for me was:
1. Make a copy of your SLAtable, let's call it SLAtable_copy, and open the copy
2. Using Query > SQL select:
Columns: *
Tables: SLAtable, SLAtable_copy
Where: SLAtable.obj Intersects SLAtable_copy.obj and SLAtable.SLA_Code
<> SLA03table_copy.SLA_Code order by 1,2
Actual feedback was this:
'just do a select query, joining the SLA_table with the duplicate (not sure
you had to do the duplicate), viz.
Select SLA_table.SLA "SLA", DupSLATable "Int_SLA" From SLA_table,
DupSLATable
Where SLA_Table.Obj Intersects DupSLATable.Obj Order by 1,2
should give the result you want with one records for each intersecting
record. Add in whatever other columns you want.'
And
'I think you could do this using a "simple" SQL statement and then same the
result as a new table.
1. Make a copy of your SLAtable, let's call it SLAtable_copy, and open the copy
2. Using Query > SQL select:
Coulmns: SLAtable.SLA, SLAtable_copy.SLA "SLA_Int"
Tables: SLAtable, SLAtable_copy
Where: SLAtable.obj intersects SLAtable_copy.obj
If you don't want to have the intersection between SLA 1 and SLA_copy 1 add
this expression to the Where clause:
and SLAtable.SLA <> SLAtable_copy.SLA
'
and
'Did you try a simple where objects from Table A intersect Objects from Table
B?'
Thankyou listers once again for your great help - I learn something new every
time I post (and if I'm lucky, even between times...)!
Regards,
Alistair
***********************************************************************************
This email, including any attachments sent with it, is confidential and for the
sole use of the intended recipient(s). This confidentiality is not waived or
lost, if you receive it and you are not the intended recipient(s), or if it is
transmitted/received in error.
Any unauthorised use, alteration, disclosure, distribution or review of this
email is prohibited. It may be subject to a statutory duty of confidentiality
if it relates to health service matters.
If you are not the intended recipient(s), or if you have received this email in
error, you are asked to immediately notify the sender by telephone or by return
email. You should also delete this email and destroy any hard copies produced.
***********************************************************************************
