Join the Live table with the table that you're extracting the value from. Don't use the exists clause. Hope that is what you're trying to accomplish.