Search results for query: *

I tried your sugestion but I get an error saying that the temp_table isn't in the database. any suggestions?

if each date is different there could be a chance that there might be 4 rows that would be returned. I only need the latest date out of the results. how would you suggest to put it into a temp table?

actully the first three querys are date stamps and the last query was a datetime stamp I changed it to a date, so now they are all the same data type.

I have this query select max (last_update) from trnsfr_main where user_id='706' union select max (last_update) from ship_main where user_id='706' union select max (last_update) from return_main where user_id='706' union select max (date(dl_date)) from file_main where user_id='706' When I run...

I didn't know there was a difference.

thanks

I tried both of the suggestions and neither one of these helped I just get general sql errors. I don't know if it makes any difference but I am on an informix database.

I have this query select max (last_update) from trnsfr_main where user_id='706' union select max (last_update) from ship_main where user_id='706' union select max (last_update) from return_main where user_id='706' union select max (date(dl_date)) from file_main where user_id='706' When I run...

Sorry for the confusion I actally got the sql stmnt to work. Here is the sql I came up with. SELECT unique user_id,COUNT (*) FROM cit_main WHERE user_id in (SELECT user_id FROM adm_users a WHERE a.supervisor in (SELECT b.user_id FROM adm_users b WHERE lower(b.login_userid) = 'mturner'))...

I have a sql statement sql += "SELECT user_id,COUNT (*) "+ "FROM cit_main "+ "c WHERE c.user_id in "+ "(SELECT user_id "+ "FROM adm_users a "+ "WHERE a.supervisor in "+ "(SELECT b.user_id "+ "FROM adm_users b "+...