Jump to content

MSAccess Query Vs. MYSQL


SuperDaveCybtro

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]
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.