sql server - SQL query inner join -

-

i want modify query in forum code, return 2 fields table tblprofile. table has 2 fields, 'emailaddress' , 'emailverified'.

this original query:

select *    (select top 10 [scirra].[dbo].[tblforumthread].thread_id,                        [scirra].[dbo].[tblforumthread].message,                        [scirra].[dbo].[tblforumthread].message_date,                        [scirra].[dbo].[tblforumthread].show_signature,                        [scirra].[dbo].[tblforumthread].ip_addr,                        [scirra].[dbo].[tblforumthread].hide,                        [scirra].[dbo].[tblforumauthor].author_id,                        [scirra].[dbo].[tblforumauthor].username,                        [scirra].[dbo].[tblforumauthor].homepage,                        [scirra].[dbo].[tblforumauthor].location,                        [scirra].[dbo].[tblforumauthor].no_of_posts,                        [scirra].[dbo].[tblforumauthor].join_date,                        [scirra].[dbo].[tblforumauthor].signature,                        [scirra].[dbo].[tblforumauthor].active,                        [scirra].[dbo].[tblforumauthor].avatar,                        [scirra].[dbo].[tblforumauthor].avatar_title,                        [scirra].[dbo].[tblforumgroup].name                               groupname,                        [scirra].[dbo].[tblforumgroup].stars,                        [scirra].[dbo].[tblforumgroup].custom_stars,                        [scirra].[dbo].[tblforumguestname].name                               guestname,                        row_number() on (order                               [scirra].[dbo].[tblforumthread].message_date asc)                                               rownum           ([scirra].[dbo].[tblforumgroup]                  inner join ([scirra].[dbo].[tblforumauthor]                  inner join [scirra].[dbo].[tblforumthread]                   on [scirra].[dbo].[tblforumauthor].author_id = [scirra].[dbo].[tblforumthread].author_id)                  on [scirra].[dbo].[tblforumgroup].group_id = [scirra].[dbo].[tblforumauthor].group_id)                  left join [scirra].[dbo].[tblforumguestname]                  on [scirra].[dbo].[tblforumthread].thread_id = [scirra].[dbo].[tblforumguestname].thread_id                      [scirra].[dbo].[tblforumthread].topic_id = 33854                 , ( [scirra].[dbo].[tblforumthread].hide = 0                        or [scirra].[dbo].[tblforumthread].author_id = 13405 ))                                   pagingquery   rownum between 1 , 10;

i've got far selecting fields:

 ,  [scirra].[dbo].[tblprofile].emailaddress,   [scirra].[dbo].[tblprofile].emailverified

but i'm bit stuck on doing join in nest!

any appreciated!

edit

sorry! need join tblprofile.userid tblauthor.author_id

ok, if understood query correctly, can try this:

select *    (select top 10 [scirra].[dbo].[tblforumthread].thread_id,                        [scirra].[dbo].[tblforumthread].message,                        [scirra].[dbo].[tblforumthread].message_date,                        [scirra].[dbo].[tblforumthread].show_signature,                        [scirra].[dbo].[tblforumthread].ip_addr,                        [scirra].[dbo].[tblforumthread].hide,                        [scirra].[dbo].[tblforumauthor].author_id,                        [scirra].[dbo].[tblforumauthor].username,                        [scirra].[dbo].[tblforumauthor].homepage,                        [scirra].[dbo].[tblforumauthor].location,                        [scirra].[dbo].[tblforumauthor].no_of_posts,                        [scirra].[dbo].[tblforumauthor].join_date,                        [scirra].[dbo].[tblforumauthor].signature,                        [scirra].[dbo].[tblforumauthor].active,                        [scirra].[dbo].[tblforumauthor].avatar,                        [scirra].[dbo].[tblforumauthor].avatar_title,                        [scirra].[dbo].[tblforumgroup].name                               groupname,                        [scirra].[dbo].[tblforumgroup].stars,                        [scirra].[dbo].[tblforumgroup].custom_stars,                        [scirra].[dbo].[tblforumguestname].name                               guestname,                        [scirra].[dbo].[tblprofile].emailaddress,                        [scirra].[dbo].[tblprofile].emailverified,                       row_number() on (order                               [scirra].[dbo].[tblforumthread].message_date asc)                                               rownum           [scirra].[dbo].[tblforumgroup]                  inner join [scirra].[dbo].[tblforumauthor]                  on [scirra].[dbo].[tblforumgroup].group_id = [scirra].[dbo].[tblforumauthor].group_id                 inner join [scirra].[dbo].[tblforumthread]                  on [scirra].[dbo].[tblforumauthor].author_id = [scirra].[dbo].[tblforumthread].author_id                 left join [scirra].[dbo].[tblforumguestname]                  on [scirra].[dbo].[tblforumthread].thread_id = [scirra].[dbo].[tblforumguestname].thread_id                  left join [scirra].[dbo].[tblprofile]                 on [scirra].[dbo].[tblprofile].userid = [scirra].[dbo].[tblforumauthor].author_id         [scirra].[dbo].[tblforumthread].topic_id = 33854                , ([scirra].[dbo].[tblforumthread].hide = 0 or [scirra].[dbo].[tblforumthread].author_id = 13405 )) pagingquery   rownum between 1 , 10;

Comments

Post a Comment

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

fortran - Function return type mismatch -

-
i'm attempting recode old c++ program in fortran make use of lapack (i'm aware c++ have lapack++, i'm having lot of trouble installing it, gave up). i didn't have problems compilation, when had variables declared real . when started coding section of program required lapack, found parameters passed dsyev need double precision . tried change double precision (including changing hard coded numbers double precision counterparts, i.e. 0.0 -> 0.0d0) when try compile, following error of functions , subroutines i've written: error: return type mismatch of function <function> @ (1) (real(4)/real(8)) i'm not sure coming from, in program has been changed double precision. for example, i've declared following: double precision :: alpha(3),d(3),zeta1,zeta2 double precision :: a1(3),a2(3),d1(3),d2(3) double precision :: pi pi = 3.14159265359d0 alpha = (/0.109818d0, 0.405771d0, 2.22766d0/) d = (/0.444635d0, 0.535328d0, 0.154329d0 /) 10 i=1,3 ...
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more