I'm writing a SQL select statement for a report and have a few requirements that I must meet.
I need to select from my orders table the First and Last name of the user
BUT I need to select them as one column in the result set, "Name". So my select would give me something like,
FirstName + " " + LastName
Is this possible? If so, how would I form the SQL?
Thanks so much for your help!