Re: Using Joins/Unions

2015-08-06 Thread Wm Mussatto
On Tue, August 4, 2015 16:05, Ryan Coleman wrote: > No but there should be. If there's not my task is useless. > > Secondly yes. Unique name on it too. > > -- > Ryan Coleman > Publisher, d3photography.com > ryan.cole...@cwis.biz > m. 651.373.5015 > o. 612.568.2749 > >> On Aug 4, 2015, at 17:33, Wm

Re: Using Joins/Unions

2015-08-04 Thread Ryan Coleman
No but there should be. If there's not my task is useless. Secondly yes. Unique name on it too. -- Ryan Coleman Publisher, d3photography.com ryan.cole...@cwis.biz m. 651.373.5015 o. 612.568.2749 > On Aug 4, 2015, at 17:33, Wm Mussatto wrote: > >> On Tue, August 4, 2015 11:19, Ryan Coleman wr

Re: Using Joins/Unions

2015-08-04 Thread Wm Mussatto
On Tue, August 4, 2015 11:19, Ryan Coleman wrote: > I have been a MySQL user and supporter for over a decade (since 2001) and > I am almost ashamed to admit that I haven’t the faintest idea on how to do > joins and unions. > > I have a specific query I would love to run… > > I have two tables, one

Using Joins/Unions

2015-08-04 Thread Ryan Coleman
I have been a MySQL user and supporter for over a decade (since 2001) and I am almost ashamed to admit that I haven’t the faintest idea on how to do joins and unions. I have a specific query I would love to run… I have two tables, one with Unique data (“images”) and one with corresponding path

Using joins to create code from E- ER relationships

2003-08-22 Thread Morten Gulbrandsen
Hello, starting from some software database spesification, defined in some Enhanced entity relationship diagram, resulting in all kinds of relationships, 1:1 1:Many Many:1 Many : many And last but not least: Subclass/superclass relationship This seems to be a small problem for me, With the cu

RE: Using Joins

2002-05-31 Thread Roger Baklund
* Arul > Is it possible that i can use 3 tables in a Join Query.. > Assuming that i have 3 tables Sure! > artist table contains artistid , artistname > cd table contains cdid,artistid , Filmname > artistaddress table contains artistid , City , phone no [...] > If i execute this query i get only

Using Joins

2002-05-31 Thread Arul
Hi All Is it possible that i can use 3 tables in a Join Query.. Assuming that i have 3 tables artist table contains artistid , artistname cd table contains cdid,artistid , Filmname artistaddress table contains artistid , City , phone no here artist acts as a Master table and cd and artistaddres