Re: What SQL query ?

Giganews Newsgroups
Subject: Re: What SQL query ?
Posted by:  Rich P (rpng1…@aol.com)
Date: 22 Aug 2006

Try this:

Select First(b.Contacts) From Companies a Join Contacts b
On a.Company_ID = b.Company_ID

Here I am using the First Function and I am uisng alias for the table
names (like shorthand).  Assuming the field/table names are the same as
your actual ones, you can paste the sql above into the sql view of a
query window and see if you get the desired results.

Rich

*** Sent via Developersdexhttp://www.developersdex.com ***

Replies

None

In response to

What SQL query ? posted by PL on Tue, 22 Aug 2006