I do not understand why my query is not working: INSERT INTO `jos_acymailing_subscriber`(`sleep_breathe`)
I have the following two SQL tables for storing movie titles, and the dates I\'ve seen them: CREATE TABLE movies (
I use old Django version 1.1 with hack, that support join in extra(). It works, but now is time for changes. Django 1.2 use RawQuerySet so I\'ve rewritten my code for that solution. Problem is, that R
I have a table of users, some of which have articles associated with them, and some of which have type = writer. I\'d like to display all users who have articles OR who have type = writer. So, all wri
I\'ve created a simple DB in EF code first but appear to have hit a problem. What I would like to do is, query the DBContext to retrieve a custom object CheckedTag that would have all of the availa
I think people were reluctant to help me last time because I didn\'t want to post up the columns, but I\'m eager to solve this, so I\'m putting aside my better judgement and laying it bare.
I have this SQL statement select st.Column1, isnull(sot.SomeColumn, 0) as SomeColumn from SomeTable st
Schema:- Part(pid, pname, price) Supplier(sid, sname,city) Part_Supplier(sid, pid) Q1) Get the supplier_id and the name for those suppliers who supply all parts.
I am getting the wrong value开发者_JAVA技巧 on gfee and netpay. SELECT s.id, s.name, c.name AS course_name,
I have 2 tables: Table : Movies MovieID -- Name 1-- Movie1 2-- Movie2 Table: Types MovieID -- Type 1-- DVD 1-- Bluray