Can you help with me this please?
I would like to know how to delete everything from this select statement and also insert them into another table.
if exists(Select empID FROM tblAvailableEmployee)
select a.AvalBusID from tblAvailableBus a inner join tblAvailableEmployee b on a.empID=b.empID
//insert them into a table called tblOutBus
then delete those records from tblAvailableBus