Re: SQL Query

From: gazzag <gareth_at_jamms.org>
Date: Wed, 16 Apr 2008 04:04:29 -0700 (PDT)
Message-ID: <09cd7a4a-41b8-4367-9487-f096ca2b2048@m3g2000hsc.googlegroups.com>


On 16 Apr, 03:55, ebingeorge.2..._at_gmail.com wrote:
> I have three table with the following structure
>
> DomainTechDetails(DomainID,DomainName, ....)
> Domains(DomainID, CustomerID, ...)
> Customers(CustomerID, CustomerName, .... )
>
> how do i retrieve the First DomainName for All Customers?

Supply:

  • the DDL to create the requisite tables
  • the DML to populate the tables with sample data
  • an example of what you've tried so far

This is the way to encourage the community to help you, grass-hopper.

HTH -g Received on Wed Apr 16 2008 - 06:04:29 CDT

Original text of this message