Re: Simple Query Question

Hi, many thanks that worked perfectly!

I'll study the statement in more detail so that I can learn from it
and understand how it functions.

I just had to enter the following modification to allow it to work on
my setup:

FROM cls.dbo.Enquiries AS E
JOIN cls.dbo.Introducers AS I

Just for clarification - I guess I have to enter the cls.dbo.enquiries
instead of dbo.enquiries because I have multiple databases within SQL
Server?

Once again, many many thanks for your help.

Lee
.

Relevant Pages

  • New Hardware, moving
    ... We have several drives configured with multiple databases on the different ... The SQL drives are on a SAN. ... stopping SQL and copying system and user databases to the new server don't ...
    (microsoft.public.sqlserver.clustering)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
Loading