Search Results

Search found 6841 results on 274 pages for 'outer join'.

Page 100/274 | < Previous Page | 96 97 98 99 100 101 102 103 104 105 106 107  | Next Page >

• MySQL GROUP BY with three tables

  - by Psaniko

  I have the following tables: posts (post_id, content, etc) comments (comment_id, post_id, content, etc) posts_categories (post_category_id, post_id, category_id) and this query: SELECT `p`.*, COUNT(comments.comment_id) AS cmts, posts_categories.*,comments.* FROM `posts` AS `p` LEFT JOIN `posts_categories` ON `p`.post_id =…

  Read the article

• issue with selecting 1 or 0 in mysql db

  - by jason

  I am having trouble with the following SQL statement i have had this issue before but I cant remember how i fixed the problem, I am guessing the issue with this is that mysql sees 0 as null ? Note I didnt show the first part of the Select statement as its irrelevant my sql works, its showing rows with toffline that are = to 1 as…

  Read the article

• Select products with users

  - by Ploppe

  I have not worked with SQL for quite a long time, and I need some help for a basic query. I have the three following tables: users (id, name) products (id, name) owners (userid, productid, date) One product can be sold by user A to user B and then back to A. Now, I want the list of all products currently owned by every single…

  Read the article

• Criteria: search for two different entity classes...

  - by RoCMe

  Hi! I have a "super entity" SuperEntity and three entities ChildEntity1, ..., ChildEntity3 which extends the super class. It's easy to search for all entities in the database, i.e. we could use session.createCriteria(SuperEntity.class); It's no problem to search for one specific entity type, too, just replace the SuperEntity…

  Read the article

• nHibernate Key Column Attribute Insert=false

  - by bharat

  How do i do an insert false on key attribute like the way we do for join

  Read the article

• Show the specific field on mysql table based on active date

  - by mrjimoy_05

  Suppose that I have 3 tables: A) Table UsrHeader ----------------- UsrID | UsrName ----------------- 1 | Abc 2 | Bcd B) Table UsrDetail ------------------------------- UsrID | UsrLoc | Date ------------------------------- 1 | LocA | 10 Aug 2012 1 | LocB | 15 Aug…

  Read the article

• No such file or directory python in linux only (coming from windows)

  - by user1804633

  I have the same exact directory structure within a folder in Windows & in Linux (Debian) - where the script is along the static + dataoutput folders How come the following code works fine in Windows, but gives a no such file or directory path error in linux? @app.route('/_getdataoutputfilelisting') def…

  Read the article

• What will or won't cause a thread to block (a question from a test)

  - by fingerprint211b

  I've had a test, and there was a question I lost some points on, because I wasn't able to answer it : Which of the following is NOT a condition which can cause a thread to block : Calling an objects's wait() method Waiting for an I/O operation Calling sleep() Calling yield() Calling join() As far…

  Read the article

• Delete rows out of table that is innerjoined and unioned with 2 others

  - by jonathan

  We have 3 tables (table1, table2, table3), and I need to delete all the rows from table1 that have the same ID in table2 OR table3. To see a list of all of these rows I have this code: ( select table2.ID, table2.name_first, table2.name_last, table2.Collected from table2 inner join…

  Read the article

• Codeigniter: how do I select count when `$query->num_rows()` doesn't work for me?

  - by mOrloff

  I have a query which is returning a sum, so naturally it returns one row. I need to count the number of records in the DB which made that sum. Here's a sample of the type of query I am talking about (MySQL): SELECT i.id, i.vendor_quote_id, i.product_id_requested, …

  Read the article

• mysql query for change in values in a logging table

  - by kiasectomondo

  I have a table like this: Index , PersonID , ItemCount , UnixTimeStamp 1 , 1 , 1 , 1296000000 2 , 1 , 2 , 1296000100 3 , 2 , 4 , 1296003230 4 , 2 , 6 , 1296093949 5 , 1 …

  Read the article

• Postgresql has broken apt-get on Ubuntu

  - by Raphie Palefsky-Smith

  On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by: The following packages have unmet dependencies: postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going to be instal led E: Unmet dependencies. Try 'apt-get -f install' with no packages…

  Read the article

• Inkscape: how to create inner border?

  - by Anton

  I create figure and set border width to 1px. My image actual size is 100px. But with border this is 102px. How to set inner border instead of o*uther border*? In Protoshop I can select type of border - inner, outer or center. But in Inkscape I not found this option. Please, help…

  Read the article

• Ctrl-Alt-Delete doesn't unlock PC when VMPlayer is on

  - by NealWalters

  My desktop XP OS gets locked after I leave for x minutes. I have VMPlayer occupying full screen mode. I think the keyboard is redirected to VMWare. I press Ctrl + Alt + Delete and outer-machine XP is not unlocking. I think maybe keyboard is going to VMWare, because this seems…

  Read the article

• How to access variables in an erb-subtemplate in puppet?

  - by c33s

  example.pp $foo = 'bar' $content = template('mymodule/maintemplate.erb') maintemplate.erb <% bar = foo + "extra" %> foobar = scope_function_template(['mymodule/subtemplate.erb']) subtemplate.erb <%# here i want to access the variable bar %> <%= bar %> …

  Read the article

• Camtasia: two independent simultaneous recordings?

  - by lance

  Can Camtasia 7 record two independent blocks of my desktop at the same time? I've got four monitors, and I want to record the events happening concurrently on the outer monitors without recording what's happening on the inner monitors during that time.

  Read the article

• onload script does not work in subview page in JSF

  - by jackrobert

  Hi, Here i write two jsp page like outerPage.jsp and innerPage.jsp The outer page include innerPage.jsp The inner page have one textfield and one button.. I need focus for textFiled while page loading(innerPage.jsp).. I write a javascript, but not work it... The code is …

  Read the article

• PHP: Convert <ul> <li> Tree HTML tag to an array

  - by marknt15

  Hi, I'm using jsTree and I need to convert this HTML tag tree code <ul> <li> to a PHP array. The jsTree HTML tag will be passed to PHP to be parsed and store in a structured tree PHP array(see below for the PHP array structure). Additional question: Is my desired…

  Read the article

• iPAD TV Commercial Released During Oscars – Steve Knows To Sell

  - by Gopinath

  Yet again Apple is at its best in making the brilliant ads of their products. Here is an excellent iPAD TV commercial released during Oscars 2010. Join us on Facebook to read all our stories right inside your Facebook news feed.

  Read the article

• Top 31 Favorite Features in Windows Server 2012

  - by KeithMayer

  Over the past month, my fellow IT Pro Technical Evangelists and I have authored a series of articles about our Top 31 Favorite Features in Windows Server 2012.  Now that our series is complete, I’m providing a clickable index below of all of the articles in the series for…

  Read the article

• Reporting Services - It's a Wrap!

  - by smisner

  If you have any experience at all with Reporting Services, you have probably developed a report using the matrix data region. It's handy when you want to generate columns dynamically based on data. If users view a matrix report online, they can scroll horizontally to view all…

  Read the article

• SQL SERVER – Difference Between DATETIME and DATETIME2

  - by pinaldave

  Yesterday I have written a very quick blog post on SQL SERVER – Difference Between GETDATE and SYSDATETIME and I got tremendous response for the same. I suggest you read that blog post before continuing this blog post today. I had asked people to honestly take part and share…

  Read the article

• Oracle Data Mining a Star Schema: Telco Churn Case Study

  - by charlie.berger

  There is a complete and detailed Telco Churn case study "How to" Blog Series just posted by Ari Mozes, ODM Dev. Manager.  In it, Ari provides detailed guidance in how to leverage various strengths of Oracle Data Mining including the ability to: mine Star Schemas and…

  Read the article

• Get the Social Networking Buzz on Gmail

  Gmail doesn&#146;t just join the social networking fray &#151; it aims to tame it.

  Read the article

• Mark Hurd and Balaji Yelamanchili present Oracle’s Business Analytics Strategy

  - by swalker

  Join Mark Hurd and Balaji Yelamanchili as they unveil the latest advances in Oracle’s strategy for placing analytics into the hands of every decision-makers—so that they can see more, think smarter, and act faster. Wednesday, April 4, 2012 at 1.0 pm UK BST / 2.0 pm CET …

  Read the article

< Previous Page | 96 97 98 99 100 101 102 103 104 105 106 107  | Next Page >