Is there a way in postgres when you
I will answer this one because I solved it by the help of Mr.@Gordon Linoff.
I use the
alias of the table and use it in the
sample code below:
SELECT a.* FROM table_a as a join table_b as b ON a.id=b.id;
This will only extract the data of