Dim sqlUnion As String = String.Format("SELECT Kreditor_ID as Kredi_ID,Kreditor as Kredi FROM tblVertrag IN '{0}' INNER JOIN tblVertragGattung IN '{0}' ON tblVertrag.ID=tblVertragGattung.VertragID WHERE GattungID=? ORDER BY Kreditor_ID UNION SELECT Kredi_ID,Kredi
FROM Projek WHERE Lager_ID=?", Server.MapPath("~/App_Data/Visieren.mdb"))
hans_v
All-Star
35986 Points
6550 Posts
Re: select two databases
Feb 20, 2012 09:57 AM|LINK
Try this:
Dim sqlUnion As String = String.Format("SELECT Kreditor_ID as Kredi_ID,Kreditor as Kredi FROM tblVertrag IN '{0}' INNER JOIN tblVertragGattung IN '{0}' ON tblVertrag.ID=tblVertragGattung.VertragID WHERE GattungID=? ORDER BY Kreditor_ID UNION SELECT Kredi_ID,Kredi FROM Projek WHERE Lager_ID=?", Server.MapPath("~/App_Data/Visieren.mdb"))