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 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 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 "+...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.