137 Topics

Member Avatar for
Member Avatar for RC_820

hii how can i make self join and sum data in other table by username i have table like this members (id, username, referral) ref_bonus (id, username, bonus) members id | username | referral ---------------------- 1 id1 id2 2 id2 null 3 id3 id2 ref_bonus id | username | bonus …

Member Avatar for pritaeas
0
96
Member Avatar for Ombu

I want to be able to write an SQL statement that pulls the sum of revenue and expenditure for each day and gets net income for each day with the distinct dates available in the Income and Expenditure tables. I have tried the following statement, but I'm not getting the …

Member Avatar for pritaeas
0
31
Member Avatar for Rachit_2

Hello can someone help me how could i start the work on a project on sentiment analysis for my college project.

Member Avatar for rproffitt
0
32
Member Avatar for kevinG73

I have a database where there is an table `wm` for water meters : +------+---------------+ | Code | name | +------+---------------+ | wm1 | water meter 1 | | wm2 | water meter 2 | | wm3 | water meter 3 | +------+---------------+ and another table c`ounters` where there are …

Member Avatar for Geek-Master
1
186
Member Avatar for wade32

I was wondering where there were other forums like this one. I really enjoy DaniWeb. There is one other forum that I really enjoy too, and its dofollow, called [SNIP - promoting my own forum] Forums like these are the reason I have helped get my site to where its …

Member Avatar for Dani
0
317
Member Avatar for larry29936

I have the following query which has died after running over an hour on my local mysql 8 server: UPDATE download LEFT JOIN lookup ON download.ip_address between lookup.start_ip AND lookup.end_ip SET ref = ( SELECT lookup.id FROM lookup WHERE download.ip_address between lookup.start_ip AND lookup.end_ip); All ip fields are IPV4 and …

Member Avatar for pritaeas
0
268
Member Avatar for fatima_7

**I need someone 2 help me drawing the ER diagram for this scenario :( ** Draw an ER Model and the corresponding relational model (logical model) for the following problem. StrongTEETH4U is a private dental clinic that is well known and has an excellent reputation in the area. All patients …

Member Avatar for Tarek_2
0
700
Member Avatar for patk570

I am using OS Ticket and I have another site for Members Area,I am trying to join the 3 tables that have the information that corresponds to the customer by EMAIL. the first table is:qbcd_ticket: ticket_id | number | user_id | user_email_id | status_id | dept_id | and more... 5 …

Member Avatar for cereal
0
405
Member Avatar for raminshahab

I have three tables that I query. Problem is my ORACLE MIF table has 500,000 rows. And it takes more than 1 hour. How can I reduce the time? SELECT WB_FIELD_REQ.MODEL, WB_FIELD_REQ.MFG_SERIAL_NUMBER, CONFIG_SERIAL_NUMBER, SH_CONTRACTS.EQUIPMENT_ID, "", SH_CONTRACTS.SERVICE, "", SH_CONTRACTS.CONTRACT, "X", "", "X" FROM WB_FIELD_REQ INNER JOIN SH_CONTRACTS ON WB_FIELD_REQ.MFG_SERIAL_NUMBER=SH_CONTRACTS.MFG_SERIAL_NUMBER NOT IN …

0
156
Member Avatar for steven.rose.94

Good Day:) I'm trying to figure out how to remove the % sign that is returned from scraping Yahoo Finance **without** removing the decimal point (or a possible negative sign in front of number returned as netProfit). My goal is to convert the string without the % sign a float …

Member Avatar for Slavi
0
2K
Member Avatar for blueguy777

I am new for MySQL my tables structures are as follows Table: registration ---------------------------------- | cardNo | mainAgentId |subAgentId| ---------------------------------- | 100 | 1 | 4 | ----------------------------------- | 101 | 1 | 5 | ----------------------------------- | 103 | 2 | 6 | ----------------------------------- | 102 | 1 | 4 …

Member Avatar for 1stDAN
0
339
Member Avatar for ehpratah

Hi need some insight on how to show record from different database on the same server. i also tried using join but didnt get the correct output. im finding a way to make it work using just one query. my last resort will be using different query to select the …

Member Avatar for ehpratah
0
335
Member Avatar for radiancebox

I'm using MS SQL 2012 - trying to LEFT JOIN 3 Pivots - but am running into issues within a query variable that I'm not sure how to debug. Each Pivot works on it's own - but the actual Joining is causing the issue. Any help is appreciated. First time …

Member Avatar for kgariando
0
3K
Member Avatar for Peter1

I have five tables as listed below. Question: is it possible to join all five tables and output the result as show below? <table> <tr> <th>Subject</th> <th>Last update (date from table. nr.3)</th> <th>Last update (date from table. nr.4)</th> <th>Last update (date from table. nr.5)</th> </tr> <tr> <td>Mathematics</td> <td>2014-06-01</td> <td>2014-07-05</td> <td>2014-03-15</td> …

Member Avatar for diafol
0
292
Member Avatar for jKidz

Hi Friends, I am developing a Music download system. I thought to have two database tables. One for songs and other one is for artists because some songs have two or more artists. Then I created two tables call `songs` and `songartists`. Following are the structures of that tables. `songs` …

Member Avatar for ms061210
0
215
Member Avatar for mohamedrani

hello, i'm joining a network which provieds me with internet connection through Lan Cable , the thing is i've to enter user name and password he gave me for only on computer online at a time, can't log in with more devices cuz he only gives me one IP i've …

Member Avatar for JorgeM
0
261
Member Avatar for Lethugs

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …

Member Avatar for Dani
0
365
Member Avatar for markii.borabon

Sir, i have a little problem regarding my queries.. I try to display data from two different table using left outer join. but I found some error.. here's my code please check and tell me what is wrong.. f(isset($_GET['id'])){ $id = preg_replace('#[^0-9]#i','',$_GET['id']); $result = mysql_query("SELECT A.cus_id, A.complaint, A.admin, A.datetime, B.firstname, …

Member Avatar for markii.borabon
0
344
Member Avatar for david.roun.7_1

Hi all. I have this code: <html> <title> </title> <head> <script> function add(){ var first=document.getElementById("form").value; var second=[first]; for (i=0;i<second.length;i++){ var third=second.join("+"); } document.one.answer.value=third; } </script> </head> <body> <input type="text" id="form" onChange="add()"/> <form name="one"> <input type="text" name="answer"/> </form> </body> </html> What I want to do is allow the user to enter …

Member Avatar for david.roun.7_1
0
193
Member Avatar for Tina_5

This is a bit complex. I have two tables *bus_status* and *routes* routes has a foriegn key look up from bus_status called UnitAssigned in routes table and it is pulled from the BusNumber field in the bus_status table. Right now when I send an email and include the field in …

Member Avatar for iamthwee
0
272
Member Avatar for vickey66

Hi, I am new to VB programming. I am using Aceess 2010 database with VB 2010. I have one main table which stores information of company details. The details are broken down in seven different tables with codes to avoid data duplication and keep the main table less bulky. e.g. …

Member Avatar for vickey66
0
297
Member Avatar for Fernando_4

Hi all, I've made a query that gathers info from several tables, after it was working, there was the need to integrate yet another table, however I can't seem to put it to work. I've seen some of this "witchcraft" before, but can't seem to find a tutorial, basically because …

Member Avatar for Fernando_4
0
466
Member Avatar for vishal anand.s

hi my name is vishal for past 5 days i have been nuts of how to combine data from multiple tables into single table using sql select query (join query) Given below i have tried solution but i get error message data not found. But in table i have datas …

0
155
Member Avatar for thilipdilip

I got a product table like this id | name | category 1 | name1 | 2,1,5,8,9 2 | name2 | 2,1 3 | name3 | 5,8 And I got a category table like this id | catname 1 | cat_name1 2 | cat_name2 5 | cat_name3 8 | cat_name3 …

Member Avatar for thilipdilip
0
2K
Member Avatar for Andrew_7

Hey guys, So, as the title says, trying to join four tables. The purpose of the script is to: 1. Get the username of members being "followed" from table called following 2. Find the status updates of members in step one from table called status 3. Retrieve all comments on …

Member Avatar for diafol
0
178
Member Avatar for pce369

So I have the following MySQL query, which works fine: select year(created_at) as year, month(created_at) as month, day(created_at) as day, item_sdb_id, price_per_unit from (select l.item_sdb_id, l.list_price / l.quantity as price_per_unit, l.created_at from listings as l inner join purchases as p on l.purchase_id = p.id where l.item_sdb_id in (12345) and p.created_at …

Member Avatar for urtrivedi
0
331
Member Avatar for ses03

i have four tables (1) tbl_module: modNo | modName _ _ _ _ _ _ _ _ 1 | module 1 2 | module 2 (2) tbl_subject subNo | subName | modNo _ _ _ _ _ _ _ _ _ _ _ _ 1 | a1 | 1 2 …

Member Avatar for Reverend Jim
0
247
Member Avatar for Gobble45

Hi All, Firstly I will say that this exercise is for my learning experiences through an online course. However I have spent a combined total of about 6 hours working on this question and I am completely stumped on how to get the correct answers. The question: > List the …

Member Avatar for rajkumar007
0
264
Member Avatar for Gobble45

Hi there, I have 3 tables to extract data from. My query thus far is: SELECT `ministry`.`pm_name` AS 'Name', DATE_FORMAT(`ministry`.`min_begin`, '%Y') AS 'Election Year', `ministry`.`party` AS 'Party Led', `deputy_name` AS 'Deputy PM', COUNT(DISTINCT `ministry`.`min_begin`) AS 'Times Elected PM', `GG_name` as 'GG Name', `gg_title` as 'GG Title' FROM `ministry` JOIN `deputy_pm` …

Member Avatar for Gobble45
0
287
Member Avatar for luma64

I have in table columns name and rc. I retrieve values by select in php by js code info array. I want to display this values in html table with other values by javascript. My question: Whats way to join values name and rc in js? I need to join …

Member Avatar for flashhtml5
0
259

The End.