Jump to content

ToniChaffin

Members
  • Posts

    4
  • Joined

  • Last visited

ToniChaffin's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Again, my thanks for you assistance. I will try and work out how to do a sub-query based on your other responseRegardsT
  2. Thanks for the script, seems to be workingRegardsT
  3. I am running SQL 2008R2. How do I run a query on the result of a query without writing the initial results to a permanent table. An example would be great. I looked through the W3Schools SQL examples but did not see anything that seemed to relate.ThanksToni
  4. I am trying to get a distinct query running based on an INNER JOIN query. However I get about 12 errors when I run the query SELECT Distinct Cust.AName, PWMain.CustRef, Cust.*FROM Cust INNER JOIN PWMain ON Cust.AName = PWMain.ContactName Does anyone know what I can do to get around this? I basically want all distinct rows from cust based on AName and only the CustRef added to the row where there is a match as stated in the T-SQL. ThanksToni
×
×
  • Create New...