Okay say I have two columns that are joined to create the index in a MS Access 2000 database. Those fields are PLS, and LINE. If I wanted to find a record with a particular PLS and LINE with SQL in the fastest way possible, can I use:
SELECT * FROM testtable WHERE (pls = blahblah and line = blahblah2)
or do i have to use some other keywords in the sql statement?
EDIT: opps wrong section
SELECT * FROM testtable WHERE (pls = blahblah and line = blahblah2)
or do i have to use some other keywords in the sql statement?
EDIT: opps wrong section