Select while in

I can't seem to find any information (I'm ALMOST positive I'm not looking in
the right place

What I'm trying to do is to select a bunch of information from one table and
then substitute the value of another table's information into the output.
Sounds crazy but let me explain:

I have two tables with different information. They both share a common
element: 'id'
Example:

Table1 Table2
id id
name type
phone dollars
fax recieved
. .
.. ..
... ...


What I would like to do is to select rows of info from Table2 and then
output the information with the 'name' from Table1.

What is the best way of doing this without obviously just adding the name as
a column on Table2?



--



"It's so muggy down here, my clothes are sticking to places on my body I
didn't even know I had."
-David Faherty

Hi
It seams easy, but I might not understend your problem

"Select Table1.name, Table2.type, Table2.dollars, Table2.received from
Table1 join Table2 on Table1.id=Table2.id"

Ventura

"Bill Y. Barool" <billiard73@hotmail.com> wrote in message
news:s6GdncqJiIvtjvrfRVn-2g@wideopenwest.com...
>I can't seem to find any information (I'm ALMOST positive I'm not looking
>in the right place
>
> What I'm trying to do is to select a bunch of information from one table
> and then substitute the value of another table's information into the
> output. Sounds crazy but let me explain:
>
> I have two tables with different information. They both share a common
> element: 'id'
> Example:
>
> Table1 Table2
> id id
> name type
> phone dollars
> fax recieved
> . .
> .. ..
> ... ...
>
>
> What I would like to do is to select rows of info from Table2 and then
> output the information with the 'name' from Table1.
>
> What is the best way of doing this without obviously just adding the name
> as a column on Table2?
>
>
>
> --
>
>
>
> "It's so muggy down here, my clothes are sticking to places on my body I
> didn't even know I had."
> -David Faherty
>

Nuno,

Thank you so much for your help! That works like a champ.
It's nice to have good examples of things, its the best way to learn.



"Nuno Ventura" <nuno.venturaatmail.telepac.pt> wrote in message
news:42674c95$0$15200$a729d347@news.telepac.pt...
> Hi
> It seams easy, but I might not understend your problem
>
> "Select Table1.name, Table2.type, Table2.dollars, Table2.received from
> Table1 join Table2 on Table1.id=Table2.id"
>
> Ventura
>
> "Bill Y. Barool" <billiard73@hotmail.com> wrote in message
> news:s6GdncqJiIvtjvrfRVn-2g@wideopenwest.com...
>>I can't seem to find any information (I'm ALMOST positive I'm not looking
>>in the right place
>>
>> What I'm trying to do is to select a bunch of information from one table
>> and then substitute the value of another table's information into the
>> output. Sounds crazy but let me explain:
>>
>> I have two tables with different information. They both share a common
>> element: 'id'
>> Example:
>>
>> Table1 Table2
>> id id
>> name type
>> phone dollars
>> fax recieved
>> . .
>> .. ..
>> ... ...
>>
>>
>> What I would like to do is to select rows of info from Table2 and then
>> output the information with the 'name' from Table1.
>>
>> What is the best way of doing this without obviously just adding the name
>> as a column on Table2?
>>
>>
>>
>> --
>>
>>
>>
>> "It's so muggy down here, my clothes are sticking to places on my body I
>> didn't even know I had."
>> -David Faherty
>>
>
>