killyridols
Registered User.
- Local time
- Today, 05:12
- Joined
- Jul 16, 2009
- Messages
- 22
SELECT distinct area.shipcode, area.cruisenum, area.corenum, lat, long, waterdepth, (data/summe)*100 AS proz
FROM nandat, indproz_pt1, area, sample
WHERE sample.sample_id=indproz_pt1.sample_id
AND sample.sample_id=nandat.sample_id
AND area.area_id=sample.area_id
AND nandat.art=98
OR nandat.art=45;
This is the query I am trying to run. Everytime I do, Access freezes ("not responding"). I'm assuming it is because of all the WHERE statements, and also because the tables NANDAT, and SAMPLE are both pretty big.
I'm trying to figure out a way, to break down this query into smaller bits so that it isn't as hard to run. I tried taking out the "(data/summe)*100 AS proz" column, and that didn't help at all...
Does anyone have any tips??
THank you!!
FROM nandat, indproz_pt1, area, sample
WHERE sample.sample_id=indproz_pt1.sample_id
AND sample.sample_id=nandat.sample_id
AND area.area_id=sample.area_id
AND nandat.art=98
OR nandat.art=45;
This is the query I am trying to run. Everytime I do, Access freezes ("not responding"). I'm assuming it is because of all the WHERE statements, and also because the tables NANDAT, and SAMPLE are both pretty big.
I'm trying to figure out a way, to break down this query into smaller bits so that it isn't as hard to run. I tried taking out the "(data/summe)*100 AS proz" column, and that didn't help at all...
Does anyone have any tips??
THank you!!