mike1reynolds
New member
- Local time
- Today, 15:42
- Joined
- Feb 22, 2008
- Messages
- 5
My last problem turned out to be an index problem w/ Pervasive.SQL. One table is imported from a spreadsheet while the other is linked from SQL, so I figured I could just add my own indexes to the imported spreadsheet and reverse the order of the INNER JOIN, but this query never returns too.
Original:
SELECT [field list]FROM sheet4 AS s INNER JOIN patient AS p
ON p.SSN=s.SSN OR p.InsId1=s.ID OR p.InsId2=s.ID
Modified:
SELECT [field list]FROM patient AS p INNER JOIN sheet4 AS s
ON s.SSN=p.SSN OR s.ID=p.InsId1 OR s.ID=p.InsId2
When importing the spreadsheet I specified both SSN and ID as indexed fields, but Access doesn't seem to be generating the indexes. Is there a special trick you have to pull in order to get the indexes to wake up?
Original:
SELECT [field list]FROM sheet4 AS s INNER JOIN patient AS p
ON p.SSN=s.SSN OR p.InsId1=s.ID OR p.InsId2=s.ID
Modified:
SELECT [field list]FROM patient AS p INNER JOIN sheet4 AS s
ON s.SSN=p.SSN OR s.ID=p.InsId1 OR s.ID=p.InsId2
When importing the spreadsheet I specified both SSN and ID as indexed fields, but Access doesn't seem to be generating the indexes. Is there a special trick you have to pull in order to get the indexes to wake up?
