iphone - Using Multiple Tables, Multiple Values with Min() SQL -


I am using SQLite in an application that I am developing.
I have a very complex query (complicated for me!) And I need basic results, but I'm stuck in finishing the last obstacle.

I have no work for this question yet which I have to do ...

SELECT SUM (ACTIVITY) ACTIVITY with activities where activity_ID (selection by name) The name of the food group name_id is named SUM (points)> 20);

I need to add another part in this query, but this is where something has become complicated for me. There are three tables ... dates, food, activities and I have to find out the amount of a result group, in which there is a minimum number between two different values ​​from two different tables, unless a certain statement is true.

Actually .. 

  from SELECT SUM (total) (SELECT MIN (value from table1, which is defined by value in Table 2, value from Table 3) Total Table 3 Table 3 contains the result set from Table 1);

The query below is something I came with, if there is no syntax (Qualified!). It does not work, but I want to understand it better what I am trying to do. (SELECT MIN (SELECT SUM (points) - 20 items where name_id IN (name = id) by SELECT SUM (activity_amount), name_id by group), activity) Activity_amount activities as activity from WHERE activity_id IN (name_id name group with name id) and name_id HAVING SUM (points)> 20);

The problem is with the first value in the MIN () .... 

  SELECT SUM (points) - 20 Food where name_id IN (Weekly = 1 from SELECT pk date) GROUP BY name_id

This statement creates more than one value, but even if I compare it to others compared to those values Requires MIN () , I only need one at a time ... not as a complete set.

How can I get something like the above mentioned query to work?

Edit ... For some examples, some example tables, thanks to Jellommannky and Hinsteck Table # 1 (date) create tables (PK Integer Primary Key, Date Integer, Weekly Integer) PK Date Weekly 1 05062009 1 2 05072009 1 3 05082009 2 Table # 2 Table Foods (PK Integer Primary Key, Food VARCHAR (64), Double Digits, Name ID IIDEGER) PK Food Points name_id 1 Food 1 12.0 1 2 Food 2 9.0 1 3 meals 3 5.0 1 4 Jan 4 15.0 2 5 Meals 5 14.0 2 6 Meals 6 12.0 3 Table # 3 (Activities) Create table activities (PK Integer Primary key, activity repeat, activity_id integer) PK activity activity_id 1 5.0 1 2 4.0 1 3 2.0 2 4 4.0 With 3 and

query from the previous post and my original post (which does not work), I would like to set one set with a value ..8.0

MIN (26.0-20, 9.0) = 6.0
MIN (29.0-20, 2.0) = 2.0 - 6.0 + 2.0 = 8.0

I hope it helps!

After very head-scratched and divining, I suspect that you may want to: Join name foods from SEPT SUM (MIN (fp-20, AP)) from FP Date (SELECT dates.pk AS FD, SM) to name name = Join FD Group FP (FP & gt; = 20) by F.G. (SELECT dates.pk AS AD, SM (Activity) Date of ARF activity_ID = Ad Group advertising) FD = VI The name of the campaign P> appears to have zero connection with their meaning, but hey, at least this gives 8.0 and the sub-selections give those other numbers which you mention !) -


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more