_taz_

I am trying to insert data from one column in one database into a column in another db. the tables already have the column in place. they both have a unique identifier column (userid) I wrote a little insert statement, but when I try it I get the following error …

[QUOTE=geek_till_itMHZ;1045486]Thats What I did but then I got an error saying Category.categoryID is and invalid column because it is not used in an aggregate function or the GroupBY Clause...so I put it in the GroupBY Clause. Problem solved...maybe[/QUOTE] that's because the analyzer stopped when it hit your first error. if …

Hi, A while back you guys helped me make a query that returns all clients that have not made a payment in 90 days. this works good. I now want to exclude those who have never made a payment. I tried to add in [CODE]Exists (Select Receipts.DateReceived from Receipts)[/CODE] but …

I have a query that works, I wanted to add another sum from another table, but when I do, the all the SUM values are wrong this works [CODE]SELECT Clients.ClientID, Clients.WholeName, SUM(CASE WHEN Payments.Creditorid = 0 THEN Payments.Amount ELSE 0.00 END) AS 'Admin Fees', SUM(CASE WHEN (Payments.Creditorid = 3) THEN …

I need help with a query. Looking though the forum and other online resources I can usually figure out what I need, but I'm drawing a blank on this one. I have a clients table which has client info in it, and a receipts table with receipt info. what I …

I need help with a left outer join on a table and some queries (is it possible to outer join with queries?) here's my SQL right now [CODE]SELECT Clients.ClientID, Clients.SSN, Clients.WholeName, Clients.Address1, Clients.Address2, Clients.City, Clients.State, Clients.ZIP, Clients.HomePhone, Clients.WorkPhone, Clients.OtherPhone, DPs.SumOfAmount AS [Client Down Payments_SumOfAmount], Remain.SumOfAmount AS [Client Remaining_SumOfAmount], [MF PTD].SumOfAmount …

Hi, I'm new here, and still a noob in sql. This is my query [code=sql] SELECT Payments.ClientID, Payments.CreditorID, Clients.FirstName, Clients.LastName, Clients.SSN, Clients.Address1, Clients.Address2, Clients.City, Clients.State, Clients.ZIP, Clients.HomePhone, Clients.WorkPhone, Clients.OtherPhone, SUM(Payments.Amount) FROM Payments INNER JOIN Clients ON Payments.ClientID = Clients.ClientID WHERE (Payments.CreditorID = 1015 or Payments.CreditorID= 1014) GROUP BY Payments.CreditorID, Payments.ClientID, …