i'm new sql, during internship required know bit of sql started learning , allowed practice on test environment(no updating, inserting or deleting displaying ), while practicing had question,this existing query:
select ab.user_id, user.email email, concat(user.firstname, ' ' ,user.lastname ) name, usl.logindatetime lastlogin, ab.creation_time datejoined, udl.deviceplatform devices, user.status status f_usr_user user inner join f_usr_account_base ab on user.id= ab.user_id inner join f_usr_dsl_log udl on ab.user_id=udl.user_id inner join f_usr_session_log usl on ab.user_id=usl.user_id group ab.user_id i want insert select query.i tried union , select within inner join didn't work(maybe structure wrong)
this query need add.this query displays number of downloaded documents each user user_id foreign key tables used in query.
select ab.user_id,count(*) total f_usr_account_base ab ,f_usr_document doc ab.user_id= doc.user_id , doc.extractioncomplete = '1' group ab.user_id; what use correctly?
there several ways this. 1 way add select clause:
select ab.user_id, user.email email, concat(user.firstname, ' ' ,user.lastname ) name, usl.logindatetime lastlogin, ab.creation_time datejoined, udl.deviceplatform devices, user.status status, ( select count(*) total f_usr_document doc ab.user_id= doc.user_id , doc.extractioncomplete = '1' ) totaldocs f_usr_user user inner join f_usr_account_base ab on user.id= ab.user_id inner join f_usr_dsl_log udl on ab.user_id=udl.user_id inner join f_usr_session_log usl on ab.user_id=usl.user_id group ab.user_id /* maybe take group out. clause filter. */ 