SQL i ACCESS, msSQL og mySQL ?
Jeg "leger" lidt med forskellige db.Sql'en her virker i Access og msSQL men hvorfor ikke i mySQL ???
'ACCESS
strSQL = "select top 999 u.* from ((docsDK u inner join ord2url o2u on u.autonum = o2u.urlid) inner join KeyWordsDK o on o2u.ordid = o.KeyWordID) where o.ord in ('"& strSearchWords &"')"
'msSQL
strSQL = "select top 999 u.* from docsDK u inner join ord2url o2u on u.autonum = o2u.urlid inner join KeyWordsDK o on o2u.ordid = o.KeyWordID where o.ord in ('"& strSearchWords &"')"
'mySQL
?!?!?!?!?!?!?!?!?!!?!? MySQL 3.23.55-nt ?!?!?!?!
