organisation (orgid, specialID, name adddress etc) a customers(orgid, exptnumber, exptename) b organisation.orgid = customers.orgidAll the queries are written in this format of
select a.column name, b.columnname etc FROM a, b where a.orgid = b.orgIDorgid is the identity column and primarykey, and the exptnumber has the UNIQUE INDEX. Can I modify this query to make it use the unique index ??? without making much changes to the structure.