Thanks - I figured out why I was having so much trouble - I was trying to use the Customer table for the from statement and due to columns and FKs, I should have used the Order table.
This is what I ended up with:
select o.CustomerID, c.lastName + ', ' c.firstName as Customer, o.OrderID...
I am new to SQL and I'm trying to write a storedprocedure that will search a customer table, get various customer info, then for each order associated with that customer, get the OrderType of each order.
Is there anyway to loop through the records in SQL since I don't have a pre-defined...
I have a weird issue that seems like it would be easy to fix.
I have a listbox that I make large enough to show 4 items at a time. Once the user selects the item they want, I reduce the size to show just one record - however, the record they selected does not show. How do I make it so that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.