WHERE COL1 = 'W03'
WHERE COL2 = 'W33'
I've got a select statement that I'm using to return two column values
from a join of two tables. I'd like to put it into a stored
procedure, but I can't seem to make the syntax work to set and return
the two values. I'm using SQL Server 7 with Delphi 5 Enterprise.
Here's the statement (:CircuitToFind is the parameter I pass in)
select c.connectionID, t.wo_id
from connections c join circuits t
on c.circuitid = t.circuitid where c.circuitID = :CircuitToFind
Is it even possible for a SP to return two values like this?
Arithmetic is being able to count up to twenty without taking off your
shoes. -- Mickey Mouse