[join] Forum Topics

Hi, I'm confused right now about mysql statement I have four tables : form1 | form2 | form3 | form4 | ----------------------------------------------------- k8regNo | form2_ID| k9regNo | form4_ID | consignee | goods | out_date| k9regNo | moveDt | k8regNo | | form2_ID | can i join this four tables..?

Hello there, I have problem as: have two tables **Candidate** and **candidate_interview** for perticular vacancy_ID , Candidate's status becomes "In Proces" and when his interview is schedule , entry is added in candidate_interview table againt that vacancy with status In Process. now what i want is , such candidates whose …

Hello, I have two tables one for the company staff and one for their projects(table name objecte). The table objekte has 4 colums that are connected with the id of the staff. The problem is that I want a query that shows all staff's names. I have also included the …

Hello, I am trying to create an outer join in Linq using DefaultIfEmpty. It does not seem to be working. Basically I want c.TotalAmount to be 0 if it does not exist in the second/right table. Any ideas as to what I might be doing wrong? The query does execute, …

I have 3 tables as mentioned below: Users Code Name NW London 1 Bill ---- ---- Contacts Code Country 1 USA Location Country City USA NW I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i …

I have a problem that I've racked my brain with for two weeks without success. I have a table named 'user_answers' containing columns 'user_answer_id' and 'user_name'. Each 'user_name' has 25 rows. I'm trying to compare/count the number of rows where user A and user B match answer_id. SELECT COUNT (*) …

Hi Guys, I need some help about join queries in SQLite manager. I wanna have some sample queries on joining one or more tables with relationship of course. PLEASE I NEED THIS FOR OUR PROJECT. Thanks. It would be an honor hearing from professionals out there. :)

Hi. I am using Zend Framework Models. I have 2 tables: 'results' and 'resources'. Table 'results' has the columns: 'results_id', 'resource_id_team1', 'resource_id_team2', 'match_result'. Table 'resources' has the columns: 'resource_id', 'resource_name'. I want to retrieve the results from the table 'results' and I want to join 2 times the table 'resources', …

Here i am trying to load data from TABLE1 to TABLE2. The requirement is to consider those records in the TABLE1"where TABLE1.COL1=TABLE1.COL1 (OR) TABLE1.COL2=TABLE1.COL2" As a single group and insert into TABLE2 with COL3 with a unique value for each group thus identified. TABLE1 ~~~~~~ COL1 | COL2 1 | …

Hi All, What Wrong with my QUERY ! it show Repetition of Record in INNER Join i.e when i have 3 record in database it show it 9 time using This query.... SELECT dbo.EmployeeSetup.EmpID, dbo.EmployeeSetup.EmpName, dbo.EmployeeSetup.FatherName, dbo.EmployeePayment.Designation, dbo.EmployeePayment.Department, dbo.EmployeePayment.Salary, dbo.EmployeePayment.Advance, dbo.EmployeePayment.Deduction, dbo.EmployeePayment.OvertimeAmount, dbo.EmployeePayment.PaymentDate, dbo.EmployeePayment.ModeOfPayment, dbo.EmployeePayment.NetPay, dbo.EmployeePayment.PayMonth, dbo.EmployeePayment.Fine, dbo.EmployeePayment.Fund, dbo.EmployeePayment.Insurence, dbo.EmployeePayment.Tax, …

I have two tables named `stockin and stockout`. I can execute query easily separately for each table. Now, I want to bind both query in a table. Please check query and output below- query in stockin: select serialno, sum(in_quantity) SUMIN, group_concat(in_quantity) GCIN from stockin group by stockin.serialno output: +----------+-------+-------------+ | …

Hi all! I don't know if that was a good title, but; I have this query (I will call it query1): "SELECT InvID, quantity FROM Recipe WHERE MenuID = 1" In my tables, this will give me something like Water(20), Oil(30) Now, from this result of a SELECT query1 (i.e …

Hi all, I have a very simple question, for many of you.. I need to write out a select list like this : From table pages, I need id and link to fill up the options in my select list. But I need to tjeck in another table, if there …

Hi, I made a page to show the information of the applications I apply and the interviews I made for selected applications and I use the inner join and left join to display data from different tables. This week I add another table to enter in it the comments. I …

Hi All, Need help with something, Im newish to PHP so have very limited knowledge. Basically I am making an admin panel for a friends beauty website. I have two different tables in my database, categories +----+----------+ |cID | cCat | +----+----------+ | 1 | Skin | | 2 | …

Hey guys, I was wondering if you could tell me if this is even possible or if it can be done another way??? So i have a database with 6 tables all the databases have the same columns except for the tables name ahead of the generic headers pub_name, Hotel_name, …

I have a CTE based query, to which I pass about 2600 4-tuple latitude/longitude values using joins - these latitude longitude 4-tuples have been ID tagged and held in a second table called coordinates. These top left and bottom right latitude / longitude values are passed into the CTE in …

Hi, I'm making a small web-based software and I need help for a search query that looks for results in 2 tables. I can run it very well like this for a single table : $query=mysql_query("SELECT * FROM `customers` WHERE `name` LIKE \"%$search%\" ORDER BY `name` ASC"); But, here is …

I'm having a problem with a MYSQL Join accross three tables. I'm new to MYSQL Join functions, and can't quite figure out how to write the code. My current code is horribly innefficient and does not implement explicit joins, which I believe is much of the problem. Here it is(in …

Hi everyone, I would like to ask a question about MySQL. Say, I have a database like this: database 1: articles |- id |- title |- description database 2: tags |- id |- articleID |- tag I needed to search from articles.description and tags.tag and while doing so, the searched …

Sir, having a problem. I have two tables i.e directives and para_comments_sect. there is no direct connection with each other . what i want is to get the data field from directives and para_comments_sect of para_id=15 ( its a foreign key from para table). any suggestions and guidance for it …

hi all! :) well i wrote a sample code to test threads and i don't get what i want the problem is that the thread i created is starting directly after i create it? but he must start when my j is equal to 25 and then i joining the …

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

Hi guys, im kind of curious, is there a query or some way to fuse two colums like `select a.col1,b.col1 from table1 a left join table2 b on a.id=b.table_a_id` then as a result i want to display only one column containing a.col1,b.col1 thanks =)

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 …

Hi, I have 3 tables 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 in Item and …

hi, im trying to write a mysql query to join tables. I basically i have the following tables: tblwinners = table that shows all the winners PK reward_id customer_id tbluser = table that holds all the user accounts PK customer_id tblcompleterewards = completed rewards PK reward_id tblrewards = holds a …

Hi I have two tables Employee and Job, Employee's prmary key is EID and in Job there is a EID that is a foreign key to Job. job has another column as the status of the employee. first the employee is added to the database and then the job detils …

'Inline Code Example HereHello i'm having this error message when adding to multiple table: '"The DataAdapter.SelectCommand property needs to be initialized." 'I need to have my data saved into both table(tblStudentInfo, tblPayment) when btnFinish clicked. Please 'help, i'm working on this for days and haven't had any luck. 'For reference …

how to left join works in mysql