I have two tables that have a parent/child relationship, where one record in the parent table may correspond to N records in the child. Both tables have an amount column that I want to aggregate in one query, so I…
I'm having results I don't understand from a MySQL query that should be pretty simple. The goal I want to achieve is more complex, but I have reduced the problem to this: When I am using NOT IN subquery in…
I'm having trouble on joining three tables. First attempt on joining two tables is success, but on third table the results are not correct... I have three tables machine_list is mainTable then applicable_rpm and applicable_product are some details of machine_list…
I have a table foo: some_fk some_field some_date_field 1 A 1990-01-01 1 B 1990-01-02 1 C 1990-03-01 1 X 1990-04-01 2 B 1990-01-01 2 B 1990-01-05 2 Z 1991-04-11 2 C 1992-01-01 2 B 1992-02-01 2 Y 1992-03-01 3 C…
I have a problem, I am making an insert using the concat to generate multiple inserts, however I realize that a null field is affecting all the queries, since the records that have null in their field, their insert is…
I have two tables Name & Zip, and i want a query to return the zip codes which are having more than 2 plans associated with one different name +------+------+ +------+------+ | TABLE: NAME | | TABLE: ZIP | +------+------+…
I need to display SQL query results by having specified columns appear first (on the leftmost side of the table). The currrent code I have is: Select * from table order by column 4, column 3, column 1 Result: column…
SELECT f.user_id, f.item_id, f.status, f.shipped, CASE WHEN f.status = 0 THEN UPDATE f SET f.status = 1 WHERE f.user_id = 1 AND f.item_id = 1 WHEN f.status = 1 THEN UPDATE f SET f.status = 0 WHERE f.user_id = 1…
I wanted to do a condition wherein I put values (000000) in DATE_COMPLETED if it see's the FLAG_CLOSED = Y and if its not Y then do nothing SELECT "JOB", "SUFFIX", "SUFFIX", "DATE_COMPLETED", "FLAG_CLOSED", CASE "DATE_COMPLETED" WHEN "FLAG_CLOSED"='Y' THEN "DATE_COMPLETED"='000000'…
I want to retrieve all buy orders with a count of matching buy orders in a single query. A match would be a sell order that satisfies all attributes (greater or equal) and is cheaper than the buy order. Is…