sql - Subquery in access with self-join, it does not recognize table alias -

-

i built subquery:

select      q2.addedquests, q2.daynum      qrnumberofqueststodo q2  inner join      qrnumberofqueststodo q3 on q2.daynum > q3.daynum      q2.daynum = (select max(q3.daynum) q3);

but ms access not recognize q3 in subquery. why?

why not? because how sql works. can refer column of q3 in subquery (in select, where, group by, having, order by, or on clause instance), not entire table.

i continuing, think query non-sensical. in 1 place, query says q2.daynum > q3.daynum. in another, q2.daynum = q3.daynum. hence, query not return anything. but, can still express valid sql. notice q3 not needed in outer query. try correlated subquery instead:

select q2.addedquests, q2.daynum qrnumberofqueststodo q2  q2.daynum = (select max(q3.daynum)                    qrnumberofqueststodo q3                    q2.daynum>q3.daynum                   )  ;

Comments

Post a Comment

Popular posts from this blog

c# - SelectList with Dictionary, add values to the Dictionary after it's assigned to SelectList -

-
i have following code - dictionary<string, string> mydict = new dictionary<string, string>(); mydict.add("keya", "valuea"); mydict.add("keyb", "valueb"); ienumerable<selectlistitem> myselectlist = new selectlist(mydict, "key", "value") further down in program, want add values mydict . possible? if yes, how? want - myselectlist.mydict.add("keyc", "valuec"); if you're wanting add items mydict, possible, , changes reflected in of myselectlist 's enumerations long changes made before enumeration (e.g. using .tolist() ) generated. as worked example: dictionary<string, string> mydict = new dictionary<string, string>(); mydict.add("keya", "valuea"); mydict.add("keyb", "valueb"); ienumerable<selectlistitem> myselectlist = new selectlist(mydict, "key", "value...
Read more

mysqli - Php Mysqli_fetch_assoc Error : "Warning: Illegal string offset 'name' in" -

-
this question has answer here: php mysqli returns 1 row 3 answers warning: illegal string offset 'name' in c:\xampp\htdocs\connection\index.php on line 31 1", please can me. <?php include('config.php'); $conn = mysqli_connect(db_host, db_user, db_pass, db_name); $sql = "select * users"; $result = mysqli_query($conn, $sql); $rows = mysqli_fetch_assoc($result); ?> and in body tag <?php foreach ($rows $row) { echo $row['name']; }?> you should use mysqli_fetch_all() here rows within $rows @ once. $sql = "select * users"; $result = mysqli_query($conn, $sql) or die(mysqli_error($conn); $rows = mysqli_fetch_all($result); echo "<pre>"; print_r($rows); // check result
Read more

javascript - Chart.js - setting tooltip z-index -

-
http://jsfiddle.net/gmannib/j2mwpj43/7/ ^ see sample fiddle above. notice how tooltips piechart go underneath "earth" icon have in middle there? there way set z-index property of tooltips above earth icon? thought work? race.tooltip.style.zindex = "5"; i'm still learning...thank kind help! just give higher z-index value canvas , done. see demo . css code canvas#race{position:relative; z-index:1;}
Read more