Jump to content

Archived

This topic is now archived and is closed to further replies.

SuperDaveCybtro

MSAccess Query Vs. MYSQL

Recommended Posts

Hello All.
I am trying to convert a query I have working fine in M$access to MySql. In access I have one table linked 4 times to allow me to compare 4 different date values to 4 different fields. This will let me check that all dates have valid data. If it passes this test I want it to append a record to my statuses table.

My Problem is that Though it works in Access Even converting it thus far it does not work in MYSQL. All it says is that the Query could not be executed.

I am not sure what other information you need but I will provide much as I can.


[code]
INSERT INTO tblstathist ( rqstid, userid, statusid )
SELECT tblrqst.RqstId, 1447, 8
FROM tblperiod,
    tblperiod tblperiod_1,
    tblperiod tblperiod_2,
    tblperiod tblperiod_3,
    tblrqst,
    vewcurrentstat
WHERE vewcurrentstat.statusid = 4 AND
  tblperiod.PeriodBeginProcessing<=now() AND
  tblperiod_1.PeriodBeginProcessing<=now() AND
  tblperiod_2.PeriodBeginProcessing<=now() AND
  tblperiod_3.PeriodBeginProcessing<=now() AND
  tblperiod.PeriodDate = tblrqst.RqstP1Stop AND
  tblperiod_1.PeriodDate = tblrqst.RqstP2Start AND
  tblperiod_2.PeriodDate = tblrqst.RqstP1Start AND
  tblperiod_3.PeriodDate = tblrqst.RqstP2Stop AND
  tblrqst.RqstId = vewcurrentstat.rqstid;
[/code]

Share this post


Link to post
Share on other sites
Not really... you have to check them all, don't you?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.