Newbie question: query over two data sources

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I need to create some SQL queries that join over two data sources.

I can easily create connection strings to these data sources, but am
unclear how to create my SQL.

I'm a real noob to this, and up until now have been using the
drag&drop tools in Vis Web Dev Express.

If I look at the asp code for queries on a single db, I understand
exactly what's going on, but can't seem to work out how to using
mutiple data sources.

Many Thanks in advance.
.

Relevant Pages

  • Re: Newbie question: query over two data sources
    ... The fundamental question is "why" do you have two identical databases ... I can easily create connection strings to these data sources, ... unclear how to create my SQL. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Windows/SQL Authentication & Connection Strings...
    ... An easy way to ensure that you have the right connection strings for SQL or ... other data sources is as ... first tab to select the kind of source - i.e. SQL Server for example. ... You can test the connection by clicking the Test Connection ...
    (microsoft.public.sqlserver.security)