Re: Need assistance with JOIN SQL

On Tuesday, December 11, 2018 at 11:07:17 AM UTC-5, paul.wi..._at_gmail.com wrote:
> I am attempting to create a report that shows both Primary and there
> Alternates however both tables I have use the same PERSON_ID identifier.
> Can someone assist me or give me something to try. The query below
> gives me output, but it only gives me Primary First Name/Last Name ect,
> email address ect ect and then it only shows the Alternates ID number
> opposed to giving me there First NAME/Last name ect ect. I know I need
> to use a join statement, but I have no experience with JOINS.
> PLEASE HELP!!
>
Hi Paul,
Did you solve this or are you still struggling?

One thing to try is to not do everything at once, but build up the query one table at a time.

Comments on how we can help:
Please provide a description of the tables, namely the primary keys and foreign keys at least. Provide some sample cases of rows for each table.

Ed Received on Sun Dec 30 2018 - 21:12:05 CET