Re: SQL beginner question - JOIN / relational database.

CAH wrote:
> Ewoud Dronkert wrote:
>> Try news:comp.databases.mysql
>
> Sorry can not do just that, my internet provider does not list it as
> yet. So if anybody knows the answer, ill apreciate a posting here.

Try news:alt.comp.databases.mysql :)

If the columns have the same name, a JOIN without ON clause will do. No
need to define anything beforehand, unless you want to have the db keep
track of referential integrity. Also see
http://dev.mysql.com/doc/mysql/en/example-foreign-keys.html

--
E. Dronkert
.

Relevant Pages

  • Re: SQL beginner question - JOIN / relational database.
    ... Ewoud Dronkert wrote: ... Sorry can not do just that, my internet provider does not list it as ... So if anybody knows the answer, ill apreciate a posting here. ... Prev by Date: ...
    (comp.lang.php)
  • Re: SQL beginner question - JOIN / relational database.
    ... > CAH wrote: ... >> Ewoud Dronkert wrote: ... >> Sorry can not do just that, my internet provider does not list it as ... Prev by Date: ...
    (comp.lang.php)
  • Re: Heras story
    ... Ewoud Dronkert wrote: ... > Robert Chung wrote: ... That dude of 1m78 and 58 kg is probably Rasmussen? ... Prev by Date: ...
    (rec.bicycles.racing)
  • Re: Getting Started on Rollers
    ... Ewoud Dronkert wrote: ... > Mad Dog wrote: ... That entry has a link to India. ... Prev by Date: ...
    (rec.bicycles.racing)
  • Re: Heras story
    ... >>Ewoud Dronkert wrote: ... That dude of 1m78 and 58 kg is probably Rasmussen? ... It's hell on the BMI, ... Prev by Date: ...
    (rec.bicycles.racing)