I wrote this query:
select name,familyname,address,mobile,phone,fax,email,website,space,make,model,color,plate,tag,memberpayment,month,year,amount,vat,expirydate,membercar,timezone,timezonename,passback
from (select name,familyname,address,mobile,phone,fax,email,website,space,make,model,color,plate,tag,memberpayment,month,year,amount,vat,expirydate,membercar,timezone,timezonename,passback,
row_number() over (partition by name order by serial) as seqnum
from membersvw
where familyname='Eliane El Asmar'
) membersvw
where seqnum = 1;
it gave me what i wanted. But once i put it in my vb code. it gives me an error: incorrect syntax near the keyword select.
This is the code:
strsql = "select serial,name,familyname,address,mobile,phone,fax,email,website,space,make,model,color,plate,tag,memberpayment,month,year,amount,vat,expirydate,membercar,timezone,timezonename,passback"
strsql = strsql & "from (select name,familyname,address,mobile,phone,fax,email,website,space,make,model,color,plate,tag,memberpayment,month,year,amount,vat,expirydate,membercar,timezone,timezonename,passback,"
strsql = strsql & " row_number() over (partition by name order by serial) as seqnum"
strsql = strsql & "from(membersvw)"
strsql = strsql & "where familyname='Eliane El Asmar'"
strsql = strsql & " ) membersvw"
strsql = strsql & "where seqnum = 1;"
Any suggestions?
And if i put * insted of : serial,name,familyname,address,mobile,phone,fax,em ail,website,space,make,model,color,plate,tag,membe rpayment,month,year,amount,vat,expirydate,memberca r,timezone,timezonename,passback
I get another error: Incorrect syntax near '('
|