MYSQL - not equal joins not working properly -

I'm having trouble finding a query to work properly, I think it should be easy, but for some reason I can not find this right.

I have two tables added to the ID field. I have all the records which are in t1 and are not visible in T2.

It currently works: AID = b.template on joining a left at AT_ templates, select

However, I want to put another condition in the query to limit the data in a subsection and it is not working: A.id = b.template where b.at_id! = 1

The second query is empty, but I want the same results as before on the basis of the input of at_id.

Any thoughts?

Your work example shows that you can record from "first table" to a Want to see and "second table" which you want to use for excluded records b if you leave all the records present in b , then you can not set any value such as b.at_id result because is in your result set b There is no value associated with

Additionally, if the condition is b.at_id is empty is true, condition b.at_id! = 1 will never be true because (the reason is that null is not a value, it is a placeholder showing absence of a value.)

If you want to get similar results from both queries based on comparison between some user input parameters and fields b.at_id (and note that your second query is currently a blank Set), you may be able to use it The Khit ways:

  SELECT * FROM at_templates as a.id = b.template a lower zone at_vault AS b where b.at_id & lt; = & Gt; 1;   
 This is a MySQL extension, not standard syntax; Unfortunately, the ANSI SQL standard syntax is different from  IS [no] , not widely supported.  
 Keep in mind that if you have some values ​​of  b.at_id  in the future that are not 1, this query will return those lines as well, and from your first query Only rows were not returned   

 




  

Popular posts from this blog

php - PDO bindParam() fatal error -

- September 15, 2015

I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');

Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

- March 15, 2015

I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177

Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

- August 15, 2014

For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...

Read more

Powered by Blogger

Theme images by Michael Elkan

Unknown

Visit profile

Archive

• September 2015200
• August 2015232
• July 2015203
• June 2015215
• May 2015200
• April 2015208
• March 2015208
• February 2015221
• January 2015205
• September 2014217

• August 2014210
• July 2014220
• June 2014194
• May 2014216
• April 2014227
• March 2014213
• February 2014192
• January 2014225
• September 2013212
• August 2013222
• July 2013217
• June 2013203
• May 2013215
• April 2013220
• March 2013210
• February 2013208
• January 2013211
• September 2012228
• August 2012205
• July 2012204
• June 2012201
• May 2012200
• April 2012221
• March 2012220
• February 2012202
• January 2012217
• September 2011222
• August 2011210
• July 2011230
• June 2011191
• May 2011219
• April 2011230
• March 2011195
• February 2011220
• January 2011225
• September 2010235
• August 2010202
• July 2010195
• June 2010198
• May 2010210
• April 2010225
• March 2010233
• February 2010195
• January 2010189

Show more Show less

Report Abuse