JOIN table results w/MySQL

[Xenophobe]

I have a query with a simple JOIN.

For example:

SELECT * FROM Companies
INNER JOIN CompanyTypes ON Companies.CompanyID = CompanyTypes.CompanyID

The query returns all fields from both Companies AND CompanyTypes. I would
like all fields from Companies only.

How can this be accomplished?

Thanks.

[Erwin Moller]

Xenophobe wrote:

I have a query with a simple JOIN.

For example:

SELECT * FROM Companies
INNER JOIN CompanyTypes ON Companies.CompanyID = CompanyTypes.CompanyID

The query returns all fields from both Companies AND CompanyTypes. I would
like all fields from Companies only.

How can this be accomplished?

Thanks.

Hi Xenophobe

what about using the columnnames instead of * ????
Didn't anybody tell you * means 'return all' in SQL?
I don't want to insult you, but I think you should do a tutorial on SQL
first, before doing more coding.
Here is a good one for starters: http://www.w3schools.com/sql/default.asp

Regards,
Erwin Moller

[Geoff Berrow]

I noticed that Message-ID: <c70Mc.147430$IQ4.55392@attbi_s02> from
Xenophobe contained the following:

The query returns all fields from both Companies AND CompanyTypes. I would
like all fields from Companies only.

How can this be accomplished?

Replace the * with whatever fields you want.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Tony Marston]

Try the following:

SELECT Companies.* from Companies .....

This way you are specifying all fields from the Companies table which
ignores all other tables.

HTH.

--
Tony Marston

http://www.tonymarston.net

"Xenophobe" <xe*******@planetx.com> wrote in message
news:c70Mc.147430$IQ4.55392@attbi_s02...

I have a query with a simple JOIN.

For example:

SELECT * FROM Companies
INNER JOIN CompanyTypes ON Companies.CompanyID = CompanyTypes.CompanyID

The query returns all fields from both Companies AND CompanyTypes. I would
like all fields from Companies only.

How can this be accomplished?

Thanks.

[Michael Fesser]

.oO(Xenophobe)

SELECT * FROM Companies
INNER JOIN CompanyTypes ON Companies.CompanyID = CompanyTypes.CompanyID

The query returns all fields from both Companies AND CompanyTypes. I would
like all fields from Companies only.

This is one of the reasons why you should avoid SELECT * (except for
short tests etc.) and list all requested columns explicitly.

Micha

[Xenophobe]

Sigh... I know asterisk means "all". I usually do specify the fields, but in
this case that's everything in my "Companies" table. For small tables with a
limited number of rows sometimes asterisk is easier.

OK, the winner is Tony.

Specifying "Companies" before the asterisk did the trick.

Thanks.

"Tony Marston" <to**@NOSPAM.demon.co.uk> wrote in message
news:cd*******************@news.demon.co.uk...

Try the following:

SELECT Companies.* from Companies .....

This way you are specifying all fields from the Companies table which
ignores all other tables.

HTH.

--
Tony Marston

http://www.tonymarston.net

"Xenophobe" <xe*******@planetx.com> wrote in message
news:c70Mc.147430$IQ4.55392@attbi_s02...

I have a query with a simple JOIN.

For example:

SELECT * FROM Companies
INNER JOIN CompanyTypes ON Companies.CompanyID = CompanyTypes.CompanyID

The query returns all fields from both Companies AND CompanyTypes. I would like all fields from Companies only.

How can this be accomplished?

Thanks.

[Geoff Berrow]

I noticed that Message-ID: <JdaMc.12152$eM2.6632@attbi_s51> from
Xenophobe contained the following:

OK, the winner is Tony.

Why? Tony's advice, though correct and specific, would not help you gain
fuller understanding.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Virgil Green]

"Geoff Berrow" <bl******@ckdog.co.uk> wrote in message
news:2k********************************@4ax.com...

I noticed that Message-ID: <JdaMc.12152$eM2.6632@attbi_s51> from
Xenophobe contained the following:

OK, the winner is Tony.

Why? Tony's advice, though correct and specific, would not help you gain
fuller understanding.

Because it answered the question that was asked, but all other response
presumed a lesson was needed and assume a pedantic tone.

Tony provided the same answer I would have provided, but I checked to see if
that answer was already made available. I might have added a note to use
correlation names to reduce the clutter.

- Virgil

[Erwin Moller]

Virgil Green wrote:

"Geoff Berrow" <bl******@ckdog.co.uk> wrote in message
news:2k********************************@4ax.com...

I noticed that Message-ID: <JdaMc.12152$eM2.6632@attbi_s51> from
Xenophobe contained the following:

>OK, the winner is Tony.
Why? Tony's advice, though correct and specific, would not help you gain
fuller understanding.

Because it answered the question that was asked, but all other response
presumed a lesson was needed and assume a pedantic tone.

<snip>

- Virgil

Hi Virgil,

I understand your response, but would like to add that OP clearly showed he
needs some more SQL lessons.
Only getting answers is often less rewarding than somebody who takes the
time to tell you what you are missing in your knowledge.
In the case of the original question I think the advise he should do more
SQL training before proceding is worth more than the actual answer.
IMHO.

I know I was corrected sometimes in the past (especially with Java) and
though it irritated me a little at the time, I was gratefull afterwards.
Why?
Because experienced people could spot the hole in my understanding by just
reading the question. They told me to study this or that first. Most of the
time they were right.
Who cares about pedantic tones anyway? I am here to learn and help others,
not to socialize.

Regards,
Erwin Moller