Search Result

user1980 · Jan 16 '12, 06:19 PM

Hi there -

I have two tables, of which table 1 records who have opened an application and table 2 records their answers.

table 1:
Std_id, Name, Status

table 2:
Std_id, Q_id, Answers

where q_id is question id.
Table 1 has one record for each student who has answered questions/just opened an application and table 2 has multiple rows for each student. The table 2 has answers...

NDayave · Nov 14 '11, 11:53 AM

Good Day,

I have a number of tables that need to be joined to gether and up to now everything has been fine. I now need to exclude old files that are identified by a sequence number; newer records have a higher number.

The joins currently look like this:

Code:

FROM a
	INNER JOIN b
		ON(a.resource_id = b.resource_id)
	INNER JOIN c
		ON(a.resource_id = c.apar_id)
	INNER

...

mcelrob5 · Apr 14 '11, 03:39 PM

I am working on a SQL statement the works on relationships mapped amongst software and hardware.

The result I am looking for from the following statement should look like this: (the example table is in code style for formatting purposes)

Code:

-----------------------------------------------
| App Name | Server | Environment | DR Server |
-----------------------------------------------
| App1     | svr1

...

Ishegg · Jan 27 '11, 07:03 PM

Hello.

I'm programming a website in which we have sport clubs listed in a DB, structure is as follows:

club (id_club, club_name, club_city)
court (id_court, court_name, club_id_club (FK), court_type)
court_has_sport (court_id_court , sport_id_sport)
sport (id_sport, sport_name)

So as you can imagine, a court may allow more than one sport to be played in it (for instance, soccer and...

AllBeagle · Nov 16 '10, 03:04 PM

Hey all,

I need to join 2 tables like the following scenario below, can anyone enlighten me as to what type of join this would be (or better yet an example of how the query would be set up)?
.....

Example -

Student Table A has 5 columns (firstname, lastname, gender, section_A_id, section_B_id)

Student Table B has 2 columns (id, sectionname)

I want this returned in 1...

xMetalDetectorx · Sep 4 '10, 06:29 PM

Hi Everyone!
I have three tables which i need to query. Here is their format:

Team
TeamID
TeamName

CoachTeam
CoachID
TeamID

PlayerTeam
PlayerID
TeamID

I need to get a list of Teams for a Coach, and that list needs to have a column for Number of Players on that team.
I can get a list of teams of a coach, and i can get the number of players...

ShelleyCook · Sep 2 '10, 03:58 PM

I have one table with the majority of the information. This table holds the following:
SalesRep (lookup from another table)
Invoice Date
Date Paid
OE
Customer
NetSale
GP
Adj GP
Rate
Paid Amount
Paid in full?
Additional Notes
Commission Payout Date
Bonus Amount

I have a query that calculates the commission by multiplying the rate times...

Pat Rowe · Jul 13 '10, 06:08 PM

Relative Newbie w/ a stumper! Any help is appreciated. Thanks!

I have two tables that I have imported to access. I'd like to query between these two tables for records that have a shared last name (under a name field) in both tables.

It's a bit complicated because the name fields in the two tables are formatted differently, and sometimes inconsistently. For example: "ROGER D & BETTY JO COLE" in table...

MusoFreak200 · Jun 28 '10, 07:13 AM

Hey, please forgive me but i couldn't find the right area.

now what i want to do is find out the manual steps that can be taken to join .rar files and/or their contents.

just like when you get a files from rapidshare and stuff.

i have not been able to find any f*ing people who can accually tell me the manual procedure.

so please don't just say, "extract it." and nothing else....

Coldfire · Jun 4 '10, 07:13 PM

Two tables

Code:

customer (id,name) = {
'1','ABC'; 
'2','DEF';
'3','GHI'
}

Code:

images (id,customer_id,subscription_id,imageURL) = {
'1','1','123','abc123.jpg'; 
'2','2','456','asdjkl.png'; 
'3','3','456','asad.gif'; 
}

I want to get the customer.name, images.id, and images.imageURL from the two tables. But,

the subscription_id should be '456'...

bscott · May 25 '10, 09:05 PM

I'm sure there is a simple solution to this, but being fairly new to Access I
would appreciate some assistance...

I have a query that joins two tables. One table has call details for each day
that an agent works. The other table has details for each call that is graded
for each agent. However, calls can be graded on days that the agent does not
work. When joining the tables, the query will only display calls...

jeff4567 · Mar 24 '10, 05:06 PM

I've got an issue where i'm trying to change names of a bunch of files in python. I've scoured the necessary directory and added the files to a list, and now im trying to remove the last 9 charecters from the filename and replace them with something new. When I try to take the letters off using fname =fname[-:9] its throwing me an error.

here's what i've got so far. Thanks for the help.

Code:

import os, sys, string

...

stretchtack · Feb 18 '10, 07:27 PM

Hey Troops,

I'm not sure if this is allowed, but I'm trying to keep my SP generic and reduce duplicate code. Depending on a condition, I need to JOIN to different tables, which slightly changes the result set. So, I would include conditions later to grab the proper fields based on checking the same condition (@TravelType = 'A').

Here's a sample of what I'm doing, which is currently giving me a syntax error near 'CASE':...

Gozil · Feb 5 '10, 06:08 PM

I'm wondering if its a good idea to separate the user information (name, pass, age ...) and the users settings (notifications, themes ...)?

I guess the real question is if its bad practice to have a lot of columns in one table or if its actually faster? One obvious reason not to have them in the same table is if you want to have dynamic settings which require one insert for each setting but I'm not gonna do that right now.

drahmani · Jun 2 '09, 06:15 PM

Can anyone tell me how to do this in Oracle?
This is not the exact query but I wanted to simplify it a little. The problem I see is that the WHERE clause depends on the join which I cannot do in Oracle.
------ A
update table1 t1
set t1.pdesc=t2.pde sc, t1.pcost=t3.pco st
from table1 t1 left outer join table2 t2 on t1.name=t2.name
left outer join table3 t3 on t2.product=t3.p roduct...

Search Result

Question about query

Looking for some help with JOIN logic

how do I join two complex Statements with different number of targets

How to get intersecting results from multiple queries (Joins)?

What type of join is this?

3 table query

Left Outter Join Confusion

How to Query Partial Match from Two Tables

How do you join rar files?

Left Join Query Problem

Query joining two tables with different dates

Convert Tuple to String

Joining to different tables based on a condition

separate user table with user settings?

Update table with multiple joins