Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?

[Karen Goh <karenworld@xxxxxxxxx>]

Sent from Yahoo Mail for iPhone

On Monday, July 22, 2019, 12:10 AM, Avin Kavish <avinkavish@xxxxxxxxx> wrote:

Hey Karen,

That query is pretty much an inner join with a filter that selects a single value from the matching rows. 

It's picking the tutor's zipcode from the tutor table where any tutor is teaching a subject called "Angela Merkel". 

For this to happen, it needs to join the tutor subjects with the tutor details table using the tutor id as the common factor.

N I need to return tutor_id so it is terribly wrong !!! So, in addition to value not being supplied. 

Perhaps you should try www.stackoverflow.com for SQL guidance. They might be able to explain in detail what you are doing (wrong). 

Make sure to provide a complete example showing all the involved relations and references and any queries your wrote. This is really

important or they downvote/close questions. (your original email is not sufficient detail)

Regards,

Avin

On Sun, Jul 21, 2019 at 8:54 PM Karen Goh <karenworld@xxxxxxxxx> wrote:

On Sunday, July 21, 2019, 11:13:58 PM GMT+8, Ron <ronljohnsonjr@xxxxxxxxx> wrote:


On 7/21/19 10:10 AM, Karen Goh wrote:

>
> On Sunday, July 21, 2019, 11:06:16 PM GMT+8, David G. Johnston
> <david.g.johnston@xxxxxxxxx> wrote:
>
>
> On Sunday, July 21, 2019, Karen Goh <karenworld@xxxxxxxxx> wrote:
>
>
> Is there a way for me to generate an entity table diagram vis pgAdmin4 or
> PSQL ?
>
>
> Just write the 5 or so tables out in a somewhat compressed format. Psql
> doesn’t and I don’t know about pgadmin
>
> Here is a compressed format :
>
> s_tutor
> --------
> zipcode(text)
> tutor_id (I just checked this is becomes a 'serial id ?' based on the
> generated sql
>
> ALTER TABLE public.s_tutor ALTER COLUMN tutor_id ADD GENERATED BY DEFAULT
> AS IDENTITY (
> SEQUENCE NAME public.tutor_strtutorid_seq
> START WITH 1
> INCREMENT BY 1
> NO MINVALUE
> NO MAXVALUE
> CACHE 1
> );
>
> tutor_subject
> ----------------
> tutor_id
> subject_Names


select s_tutor.zipcode
from s_tutor, tutor_subject
where s_tutor.tutor_id = tutor_subject.tutor_id
and tutor_subject.subject_names ='Angela Merkel'

Hi Ron,

Could you explain why you select s_tutor.zipcode from tutor_subject since there is no zipcode inside tutor_subject?

Perhaps my reasoning is wrong and I really want to have your expert view.


--
Angular momentum makes the world go 'round.