IF (EXISTS(Select * from sys.systable where LCase(table_name) = LCase('v_TelTalksGuests')))
THEN Drop view v_TelTalksGuests
END IF

GO

create view
  DBA.v_TelTalksGuests
  as select GuestNum,Guests.Name,
    CallDate,CallTime,
    IntLine,ExtLine,
    DialNumber,Duration,
    PulseCount,CallPrice,
    --Maria
    --ServiceCredits.RoomNum from
    Rooms.RoomName from
    --Maria
    ((DBA.ServiceCredits join DBA.Guests on ServiceCredits.WhoPays = Guests.GuestNum)
	join DBA.PBXCallsLog on PBXCallsLog.N = ServiceCredits.PBXLogN) 
	left outer join DBA.Rooms on ServiceCredits.RoomNum = Rooms.RoomNum  
	--where Rooms.PBXNumber like string('%,',PBXCallsLog.IntLine,',%')
    --Maria
//[v 01.06.15]