SELECT * FROM tel RIGHT OUTER JOIN "namn-tel" ON tel.id="namn-tel".telid WHERE "namn-tel".namnid=@nID
NB that in order for this question to work I have to use the "-sign around the table names that contain a - -sign, i.e. namn-tel.
Now, how do I use this from VB as a sqlcommand.commandtext since the "-sign will end the string I'm sending to the DB?
I've tried using ' instead but it didn't work and I have searched some here and on the net for the combination " AND - AND commandtext.