[dba-SQLServer] Newbie needs help with select statement

In order to "link" the tables together,
they have to have a column in common
between them.


At 09:53 AM 2/2/2009, you wrote:
>Date: Sat, 31 Jan 2009 18:08:59 -0500
>From: jean-paul <jnatola at hotmail.com>
>Subject: Re: [dba-SQLServer] Newbie needs help with select statement
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <BAY140-W35C4C003451CFC6EA8C7E0BCC70 at phx.gbl>
>Content-Type: text/plain; charset="Windows-1252"
>
>
>the contacts table does NOT have organization type- it has
>
>id, first, last, add , cty, st, zip, tel, fax, dte_created,  email, 
>etc..  but nothing regarding organization type-   I will try you 
>code and let you know- if been on this for the last 30 
>hours  racking my brain- on a good note i  read and learned 
>alot  since yesterday
>
>btw,  I'm using MySQL  and doing this via phpMyAdmin- if it makes 
>any difference
>