[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    [SQL] Help needed
From:       "Mowat, Paul" <Paul_Mowat () bmc ! com>
Date:       2002-08-27 9:20:58
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Dear postgresql,
I am just starting to learn SQL.
I have attached a script that allows me to create some tables and indexes. I
have rows that are inserted into the tables.
 
I need some help with creating multiple subqueries and table joins, (six or
seven table joins).
Can you help?

Paul Mowat 
Software QA Engineer 
Enterprise Data Management 
--------------------------------------- 
BMCSoftware 
Abingdon UK 

Direct: +44 1235 827408 
Fax:    +44 1235 827430 
Email: paul_mowat@bmc.com. 
www.bmc.com 

 

[Attachment #5 (text/html)]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 6.00.2715.400" name=GENERATOR></HEAD>
<BODY style="COLOR: #000000; FONT-FAMILY: Arial">
<DIV><SPAN class=339321709-27082002><FONT size=2>Dear 
postgresql,</FONT></SPAN></DIV>
<DIV><SPAN class=339321709-27082002><FONT size=2>I am just starting to learn 
SQL.</FONT></SPAN></DIV>
<DIV><SPAN class=339321709-27082002><FONT size=2>I have attached a script that 
allows me to create some tables and indexes. I have rows that are inserted into 
the tables.</FONT></SPAN></DIV>
<DIV><SPAN class=339321709-27082002><FONT size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=339321709-27082002></SPAN><FONT 
size=2>I&nbsp;need&nbsp;some&nbsp;help&nbsp;with&nbsp;creating&nbsp;multiple&nbsp;subq \
ueries&nbsp;and&nbsp;table&nbsp;joins,&nbsp;(six&nbsp;or&nbsp;seven&nbsp;table&nbsp;joins).</FONT></DIV>
 <DIV><SPAN class=339321709-27082002></SPAN><SPAN 
class=339321709-27082002></SPAN><FONT size=2>C<SPAN class=339321709-27082002>an 
you help?</SPAN></FONT></DIV>
<P><FONT face="Times New Roman" size=2>Paul Mowat</FONT> <BR><FONT 
face="Times New Roman" size=2>Software QA Engineer </FONT><BR><FONT 
face="Times New Roman" size=2>Enterprise Data Management</FONT> <BR><FONT 
face="Times New Roman" size=2>---------------------------------------</FONT> 
<BR><FONT face=Arial color=#0000ff size=4>BMC</FONT><FONT face=Arial 
color=#c0c0c0 size=4>Software</FONT> <BR><FONT face="Times New Roman" 
size=2>Abingdon UK</FONT> </P>
<P><FONT face="Times New Roman" size=2>Direct: +44 1235 827408</FONT> <BR><FONT 
face="Times New Roman" size=2>Fax:&nbsp;&nbsp;&nbsp; +44 1235 827430</FONT> 
<BR><FONT face="Times New Roman" size=2>Email: paul_mowat@bmc.com.</FONT> 
<BR><FONT face="Times New Roman" size=2>www.bmc.com</FONT> </P>
<DIV>&nbsp;</DIV></BODY></HTML>


["BaseSetofObjects.sql" (application/octet-stream)]

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic