mysql - Joining multiple columns from table a to one on table b -

-

i've spent bit of time researching on here , mysql site i'm bit confused on 2 things: sort of join use , how (or if) use alias.

the query:

select forum_threads.id, forum_threads.forum_id, forum_threads.sticky,  forum_threads.vis_rank, forum_threads.locked, forum_threads.lock_rank, forum_threads.author_id, forum_threads.thread_title, forum_threads.post_time,  forum_threads.views, forum_threads.replies, users.username author_username  forum_threads left join users on forum_threads.author_id = users.id forum_threads.forum_id=xxx

now query finds threads given forum , joins threads author id username table. have lastpostid i'd include in query , join again on users table can username last poster too.

i tried adding:

left join users on threads.lastpostid = users.username

but results in alias error users isn't unique.

i tried using both alias on main query , on second join keeps giving me missing field errors.

could give me point in right direction please?

yes, need different alias each time. every time refer table in query should use approprate alias.

select      forum_threads.id,      -- etc...,      forum_threads.replies,      u1.username author_username       u2.username last_post_username  forum_threads left join users u1 on forum_threads.author_id = u1.id left join users u2 on threads.lastpostid = u2.username  forum_threads.forum_id=xxx

Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more