Convert MS SQL Query to MS Access

Question

User-1249732592 posted

I have write a query in MS SQL 2005 but i want to use this query in MS Access.

My SQL Query doesn't work in MS ACCESS..

What is exact query for MS Access.

SELECT a.DATEANDTIME,a.VAL AS 'Batch ID', b.val as 'Set Weight', c.val as 'NET Weight' , d.val as 'Gross Weight'FROM FLOATTABLE as a JOIN Floattable as b on a.dateandtime = b.dateandtime JOIN Floattable as c ON a.dateandtime = c.dateandtime JOIN Floattable as d ON a.dateandtime = d.dateandtime WHERE a.TAGINDEX = 0 AND a.VAL = 1 AND b.TagIndex = 2 AND c.tagindex = 3 AND d.TagIndex = 4

Answer 1

User-906034138 posted

SELECT
 a.DATEANDTIME,
 a.VAL AS 'Batch ID',
 b.val as 'Set Weight',
 c.val as 'NET Weight' ,
 d.val as 'Gross Weight'
FROM
FLOATTABLE a,Floattable b,Floattable c,Floattable d
where a.dateandtime = b.dateandtime and a.dateandtime = c.dateandtime and a.dateandtime = d.dateandtime and  a.TAGINDEX = 0
 AND a.VAL = 1 AND b.TagIndex = 2 AND c.tagindex = 3 AND d.TagIndex = 4 

Answer 2

User-1249732592 posted

Thanks parthasbhadra..