Sponsored Content
Top Forums Programming sql query to match condition from other table (time sensitive) Post 302540136 by computethis on Tuesday 19th of July 2011 05:37:56 PM
Old 07-19-2011
sql query to match condition from other table (time sensitive)

I know little SQL and could really use a hand here. I need to get the fields last_name, first_name and email from the table users and only if the entery with the same pkey in the table addresses, in the city column is Seattle.

So if the city in the addresses table is Seattle, go to the table users, find the same pkey and extract the first_name, last_name and email. Am I being clear?

Thanks very much for the help,
Ed Guntrum
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

2. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies

3. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies

4. UNIX for Dummies Questions & Answers

Query in if condition

---- srcfile=/xxx/yyy/abc.txt Mode=1 if ; then echo "inside if" else echo "not inside if" fi ---- The size of the file /xxx/yyy/abc.txt is 1 mb If i exec the above if condition, what is the output that i will get? what does "-o " means in the if condition The... (1 Reply)
Discussion started by: kmanivan82
1 Replies

5. Shell Programming and Scripting

Shell scripting unable to send the sql query data in table in body of email

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email. spool table_update.html; SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription'; spool off; exit; Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies

6. Shell Programming and Scripting

Request: How to Parse dynamic SQL query to pad extra columns to match the fixed number of columns

Hello All, I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns. So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies

7. Shell Programming and Scripting

I want query output to send on mail using table tag and output should be in table

#! /bin/ksh #] && . ./.profile 2>/dev/null if test -f '.profile'; then . ./.profile; fi; #. .profile LOG_DIR=/app/rpx/jobs/scripts/just/logs sendEmail() { pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7" ( ... (21 Replies)
Discussion started by: ankit.mca.aaidu
21 Replies

8. Solaris

SQL QUERY to Table Output

Hi I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p inner join v$session se on p.addr = se.paddr inner join ( select... (2 Replies)
Discussion started by: tharmendran
2 Replies

9. Programming

DB2 Query to check table counts,start end time

Dear team I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids . Currently i am using below query but this displays table name and counts for latest run. select name ,CARD from... (0 Replies)
Discussion started by: Perlbaby
0 Replies
LedgerSMB::Location(3pm)				User Contributed Perl Documentation				  LedgerSMB::Location(3pm)

NAME
LedgerSMB::Location - LedgerSMB class for managing Business Locations SYOPSIS
This module contains location management routines. This subclasses LedgerSMB::DBObject to provide access to automatice mapping of function arguments and the like. METHODS
delete save Saves the location. Properties to be set to be saved are: * location_id: Optional: Overwrite location with this id. * address1: First line of the address. * address2: Second line of the address * address3: Third line of the address * city * state: state or province * zipcode: zipcode or mail code, * country: The id of the country as per the country table get Retrieves a location record based on the id field of the object. Merges the properties into the object. search Returns anarrayref (and stores it on $self->{search_results} based on the search of addresses. Not currently used. Attributes used as search criteria: address1: Partial match for address line 1 address2: Partial match for address line 2, city: Partial match for city name state: Partial match for state or province name, zipcode: Partial match for zip or postal code, country: Partial name for country name) list_all Provides a list of all locations, ordered by country, then city, then state. delete Deletes the location identified by id Copyright (C) 2007, The LedgerSMB core team. This file is licensed under the Gnu General Public License version 2, or at your option any later version. A copy of the license should have been included with your software. perl v5.14.2 2011-07-06 LedgerSMB::Location(3pm)
All times are GMT -4. The time now is 12:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy