Hi Folks
how can convert sql query to sp :

SELECT MACHINE.machine_id,
MACHINE.machine_name
FROM MACHINE
WHERE MACHINE.in_station = 'Bank'

And this .

SELECT DISTINCT MACHINE.type_id,
MACHINE_TYPE.type
FROM MACHINE,
MACHINE_TYPE
WHERE ( MACHINE.type_id = MACHINE_TYPE.type_id ) and
( ( MACHINE_TYPE.machine_level = "FIB" ) AND
( MACHINE.in_station ='Bank' ) )

Thank you very much
efrat
[email protected] (Tom is busy)