Help... How Do I?

[Quoted] Hi All!

I'm trying to figure out exactly how to get this query written, and hope someone out here can give me a hand. First a description of what I'd like to be able to do:

        I have a table in our database that keeps track of how many sessions are open and how many user licenses are in use at any given time. What I'd like to be able to do is do a count of that table where a specific condition exists (that's not a problem at all) and then take the results of that count and make it part of an insert command into another table (that's what I don't know how to do). Logically it would flow like this:

[Quoted] 	select count(*) from seat_assignment where s_add_on_cd != 'N/A';
	insert into stats (logged_on, system_date) values ('<results of the

A case of knowing where I want to get to, but not knowing the path to get there.

Thanks in Advance!

Harvey Received on Sun May 14 2000 - 00:00:00 CEST