Link to home
Start Free TrialLog in
Avatar of Newton
Newton

asked on

Join multiple sql in postgresql

I have below 3 sql but I need 1 sql that can show all 3 result as 1 output

Sql : select current_database();
Output : dbname

Sql : select inet_server_addr();
Output : 101.99.234.20

Sql : select user;
Output : userA

Above is 3 different output but I need 1 sql that can give 1 output like below.

Output
Current_database,ip,user
Dbname, 101.99.234.20, userA

Is it possible to join these sql.
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Create a VIEW that "collects" data from the 3 Tables.
Use Union all to combine all 3 queries.
Avatar of Newton
Newton

ASKER

Thank You Ryan. My problem solved.