Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB Tools

Lost Password?

Thread Tools Display Modes
Old 10-31-2015, 01:52 PM
verylucky verylucky is offline
Junior Member
Join Date: Mar 2013
Location: Rome
Posts: 3
Lightbulb Help with sql

Hi all

i need an help to perform a query on 2 tables and the fastest way to do it.

In my XE6 application i have 2 forms and 2 ADOtables: in form 1 (ADOtable1) i extract past betting quotes from the web and the final match result (1X2).

In form 2 (ADOtable2) i collect the match still not played and their betting quotes.

What i need: in table2, for each row of the upcoming matches, i need to insert how many times a match (from Table1) whit the SAME quotes finished with 1, X or 2 and populate the FV1-FVX-FV2 fields and the FVTOT field with the sum of FV1-FVX-FV2.

In practice i need to know how many times a match whit betting quotes: 2,3 - 3,25 - 2,7 (attached image 2) ended (in table1) with an home win (1) a draw (X) or an Away win (2) and the sum of these 3 values, which represent the total frequency in table 1 of an event whit the same betting quotes.

Thankyou in advance for your help and excuse me for my bad english
Attached Images
File Type: jpg Image1.jpg (41.4 KB, 9 views)
File Type: jpg Image2.jpg (47.1 KB, 7 views)

Last edited by verylucky; 10-31-2015 at 02:00 PM.
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 10:13 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.