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
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
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
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
----
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
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
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
#! /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
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
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
LEARN ABOUT DEBIAN
ledgersmb::location
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)